adams.squared (10/4/2013)
I have over 30,000 customer IDs. Reading the split, it looks like it can handle 8,000 characters.
Maybe you need a couple of queries then. If they want all the customers there really is no need to split anything, just return them all.
Something like this. You might even want to split each of the IF conditions to its own stored proc depending on how this performs
If @CustNums is null
--Query to return ALL customers
select *
from YourTable
else
--Query that parses them
select *
from YourTable
cross apply dbo.DelimitedSplit8K(@CustNums, ',')
_______________________________________________________________
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/