SQL Server – In clause with a declared variable [duplicate]

by

This is an example where I use the table variable to list multiple
values in an IN clause. The obvious reason is to be able to change
the list of values only one place in a long procedure.

To make it even more dynamic and alowing user input, I suggest
declaring a varchar variable for the input, and then using a WHILE to
loop trough the data in the variable and insert it into the table
variable.

Replace @your_list, Your_table and the values with real stuff. 

DECLARE @your_list TABLE (list varchar(25)) 
INSERT into @your_list
VALUES ('value1'),('value2376')

SELECT *  
FROM your_table 
WHERE your_column in ( select list from @your_list )

The select statement abowe will do the same as:

SELECT *  
FROM your_table 
WHERE your_column in ('value','value2376' )

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Insert local .csv data in remote SQL Server via already working connection string
  3. Syntax combine two stored procedure into one [closed]
  4. How to delete duplicate rows in SQL Server?
  5. CROSS JOIN vs INNER JOIN in SQL
  6. How can I schedule a job to run a SQL query daily?
  7. Reset identity seed after deleting records in SQL Server
  8. How to avoid the “divide by zero” error in SQL?
  9. Multiple INSERT statements vs. single INSERT with multiple VALUES
  10. Real life example, when to use OUTER / CROSS APPLY in SQL
  11. How to print VARCHAR(MAX) using Print Statement?
  12. Default row order in SELECT query – SQL Server 2008 vs SQL 2012
  13. How to update Identity Column in SQL Server?
  14. Concatenate values based on ID
  15. How to convert an integer (time) to HH:MM:SS::00 in SQL Server 2008?
  16. What is the order of execution for this SQL statement
  17. How to import text files with the same name and schema but different directories into database?
  18. Detect consecutive dates ranges using SQL
  19. Select a Column in SQL not in Group By
  20. Split values over multiple rows [duplicate]
  21. How to do an inner join on row number in sql server
  22. How can I alter this computed column in SQL Server 2008?
  23. How to get the size of a varchar[n] field in one SQL statement?
  24. IN Clause with NULL or IS NULL
  25. SQL Server: should I use information_schema tables over sys tables?
  26. TSQL – How to use GO inside of a BEGIN .. END block?
  27. Cumulative Total in MS Sql server [duplicate]
  28. How to write a WHERE Clause to find all records in a specific month?
  29. How to make a view column NOT NULL
  30. SQL Server equivalent of WM_CONCAT function [duplicate]

Leave a Comment