Viewing 4 posts - 1 through 4 (of 4 total)
Try it, with your test data. You'll see the error message that SQL returns.
I figured that it would with more than 1 row. In...
March 23, 2017 at 8:07 am
Based on the explanation (and a bit of trial and error), the following seems to do exactly what I had wanted with minimal redundant select statements:
March 23, 2017 at 7:23 am
Thanks for the explanation and excellent example
It makes sense the way that you have described it.
Mike
March 23, 2017 at 5:36 am
Strangely enough, this seems to work:
--Need to find Case --
Select [CASES].[NUMBER], [CASES].[IMPROVEMENT] FROM [CASES] WHERE [CASES].[NUMBER] = @iCase;
IF @@Rowcount = 1...
March 23, 2017 at 4:57 am
Viewing 4 posts - 1 through 4 (of 4 total)