SQL Switch/Case in ‘where’ clause

declare @locationType varchar(50);
declare @locationID int;

SELECT column1, column2
FROM viewWhatever
WHERE
@locationID = 
  CASE @locationType
      WHEN 'location' THEN account_location
      WHEN 'area' THEN xxx_location_area 
      WHEN 'division' THEN xxx_location_division 
  END

Related Posts:

  1. How do I use properly CASE..WHEN in MySQL
  2. Case in Select Statement
  3. Case statement in MySQL
  4. “CASE” statement within “WHERE” clause in SQL Server 2008
  5. What is a stored procedure?
  6. Unknown column in ‘field list’ error on MySQL Update query
  7. SQL Inner-join with 3 tables?
  8. Conversion failed when converting date and/or time from character string while inserting datetime
  9. MySQL create table if not exists and insert record only if table was created
  10. error, string or binary data would be truncated when trying to insert
  11. How can I do an UPDATE statement with JOIN in SQL Server?
  12. ORA-00907: missing right parenthesis
  13. Rename column SQL Server 2008
  14. Why do we need “Relationships” between tables at all?
  15. Using group by on multiple columns
  16. How to declare a variable in MySQL?
  17. ORA-01843 not a valid month- Comparing Dates
  18. Drop a temporary table if it exists
  19. How do I escape a single quote in SQL Server?
  20. ORA-00918: column ambiguously defined in SELECT *
  21. Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
  22. How Stuff and ‘For Xml Path’ work in SQL Server?
  23. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  24. Oracle SELECT TOP 10 records
  25. must appear in the GROUP BY clause or be used in an aggregate function
  26. How can I return pivot table output in MySQL?
  27. Compare dates in MySQL
  28. Best way to do nested case statement logic in SQL Server
  29. The multi-part identifier could not be bound
  30. MySQL syntax for Join Update
  31. Get day of week in SQL Server 2005/2008
  32. SQLite – UPSERT *not* INSERT or REPLACE
  33. how to drop partition without dropping data in MySQL?
  34. Simple way to calculate median with MySQL
  35. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  36. Error 1046 No database Selected, how to resolve?
  37. What is it exactly a BLOB in a DBMS context
  38. missing FROM-clause entry for table
  39. How do you create a temporary table in an Oracle database?
  40. Oracle SQL: Update a table with data from another table
  41. How to SUM and SUBTRACT using SQL?
  42. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  43. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  44. Postgresql tables exists, but getting “relation does not exist” when querying
  45. Sql query to insert datetime in SQL Server
  46. SELECT DISTINCT on one column
  47. TSQL PIVOT MULTIPLE COLUMNS
  48. MySQL – UPDATE multiple rows with different values in one query
  49. Postgres Error: More than one row returned by a subquery used as an expression
  50. How to create a MySQL hierarchical recursive query?
  51. Microsoft OLE DB Provider for SQL Server error ‘80004005’
  52. Comparing Dates in Oracle SQL
  53. How to divide two columns?
  54. MySQL starts with searching issue
  55. SQL Parentheses use in an OR clause
  56. Is it possible to GROUP BY multiple columns using MySQL?
  57. What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
  58. Equivalent of Oracle’s RowID in SQL Server
  59. Is there a Max function in SQL Server that takes two values like Math.Max in .NET?
  60. Best way to test if a row exists in a MySQL table
  61. Subtract one day from datetime
  62. Get current year in TSQL
  63. Is it possible to specify condition in Count()?
  64. SQL Server: Make all UPPER case to Proper Case/Title Case
  65. using sql count in a case statement
  66. How do I query for all dates greater than a certain date in SQL Server?
  67. Backup a single table with its data from a database in sql server 2008
  68. updating table rows in postgres using subquery
  69. Conditional JOIN Statement SQL Server
  70. Temporary table in SQL server causing ‘ There is already an object named’ error
  71. MySQL OPTIMIZE all tables?
  72. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  73. Is there a coalesce-like function in Excel?
  74. How do I count unique items in field in Access query?
  75. Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine
  76. Append table to an existing one: SQL Server
  77. How to order by column A and then by column B?
  78. SQL Server – An expression of non-boolean type specified in a context where a condition is expected, near ‘RETURN’
  79. MySQL LIKE IN()?
  80. Filter data based on date in sql
  81. What is a postgres superuser
  82. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  83. SQL query to extract only the “current” wp_posts?
  84. How to retrieve sticky post in raw sql?
  85. How to remove in the wordpress database all posts revisions except the last three?
  86. How do I move a WordPress site to another server?
  87. Backticks (`) Instead of Single Quotes (‘) in an SQL Statement?
  88. $wpdb get_var issue
  89. WP Optimization: Removing Orphaned wp_options (especially the autoload ones)
  90. Auto-update tables from database
  91. Inserting rows into a custom table, when plugin is activated
  92. dbDelta not creating table (yes, once more)
  93. Posts modified in the last 48 hours
  94. post id not displaying
  95. How to export 2 week’s worth of posts
  96. Insert multiple checkbox values
  97. How to get EVENT based on startday, using BETWEEN
  98. wpdb prepare without placeholder
  99. Adding profile data to database
  100. Firebase with WordPress instead of SQL?

Leave a Comment

techhipbettruvabetnorabahisbahis forumutaraftarium24eduedueduseduseduseduseduedusedusedu