There's got to be a better way...
I'm developing a sProc for SQL7: SELECT * FROM x WHERE
LocationID IN ([List of LocationIDs]).
I'd like to pass a variable number of IDs to the sProc
(who wouldn't?). When I use a delimited varchar parameter
and pass it to the SELECT statement I get an error.
Perhaps there's a better approach. Thanks in advance.