SELECT * FROM mstinstrument where instrumentid IN (@intid); is equivalent to
SELECT * FROM mstinstrument where instrumentid = @intid;
So looking for
SELECT * FROM mstinstrument where instrumentid = '''BSEC0002'',''BSEC0001''';
Should be clear why that returns no data.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Thanks for clarification.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply