I have a SP where a select a group of records based upon an ID passed. The ID is a string, max size is Character 8.
For a single id this works.
select fk_name where cattorneyid = @firmid
This also works for a single id.
select fk_name where cattorneyid in (@firmid)
These are both run using exec Attorney_list '000449'
However, I cannot pass a string containing more than 1 ID.
exec Attorney_list '000449,105690'
OR
exec Attorney_list "'000449','10105690'"
Any ideas how I can pass a string with variable number of ids and run the select statement?
Fred Lauckner
You know, it works on my computer. I don't know what your problem is.
.Net aint so bad.