Viewing 3 posts - 1 through 3 (of 3 total)
The answer for this is:
EXEC sp_executesql @sqlToExec, N'@ordernumber MSS_MC1_LookUpIds READONLY, @permmasterlistid MSS_MC1_LookUpIds READONLY, @externalordernumber MSS_MC1_LookUpIds READONLY',
@ordernumber, @permmasterlistid, @externalordernumber
October 15, 2021 at 12:08 am
Thank you very much for the response and the links. They really helped me but I have one more question now.
I am using multiple TVPs in my stored procedure and...
October 14, 2021 at 11:59 pm
If we have multiple parameters in one stored procedure and if any of those parameters has value empty, we should not us skip using a condition related to that parameter...
October 14, 2021 at 12:14 am
Viewing 3 posts - 1 through 3 (of 3 total)