richardmgreen1 (4/19/2013)
Hi allI've got a couple of queries that use quite large comma separated lists in the WHERE clauses.
I've seen (somewhere) a way of putting these into some sort of variable and using the variable instead of the entire list in the WHERE clause.
Would someone be kind enough to point me in the right direction?
Not quite sure what you mean. If you used a variable you would have to use dynamic sql and I don't think that is what you want here.
If you mean you are passing a delimited list as a string you can parse string. If that is the case you can check the article in my signature about splitting strings.
If you could post some code or some more details about what you are trying to do I will be happy to help.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/