kenneth.bucci (1/18/2013)
Yes that is what I am saying @Issues is a SQL Paramerter with multiple delimited values separated with a comma. SPL.IssCode contains a different set of multiple delimited values separated with a comma. I would like to compare @Issues against SPL.IssCode. I hope that makes better sense.Thank you for your help!!
Please post ddl, sample data and desired output as outlined in the first link in my signature. This is relatively easy but I can't help with the code because I have nothing to work with. Help me to help you and you will be rewarded with fast, tested and reliable code.
_______________________________________________________________
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/