Viewing 4 posts - 1 through 4 (of 4 total)
This is how we fixed it:
(@Issue is not null and exists
(select 1 from IssueCodes where charindex(IssueCode, @Issue) <> 0 AND charindex(IssueCode, SPL.IssCode) <> 0)))
Works like a charm!
January 21, 2013 at 9:52 am
Thank you both for your replies.
Unfortunately I have to be careful what gets posted publicly as I work for a hospital. I am not sure I could get you sample...
January 18, 2013 at 2:10 pm
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...
January 18, 2013 at 1:56 pm
Thank you for your reply.
I am still not sure how to compare the two sets of delimited string items. Each item in one list must be in the other string....
January 18, 2013 at 1:38 pm
Viewing 4 posts - 1 through 4 (of 4 total)