By Charles Thomas Blankenship - 3/31/2014
Unfortunately I cannot get an imbedded image or a code snippet to format properly so I have to format the question using Word and DropBox ... sorry.
https://www.dropbox.com/s/m9az2zk4mlihh4d/ExecuteScalarQuestion.docx
Thanks in advance.
C. T.
|
By Edhy Rijo - 3/31/2014
Hi Charles,
Try adding the following at the top of your stored procedure.
SET NOCOUNT = ON
|
By Charles Thomas Blankenship - 3/31/2014
Thanks Edhy:
SET NOCOUNT ON was 50% of the solution … adding the SELECT @@ROWCOUNT beforethe COMMIT TRAN was the other 50%
C. T.
|
By Edhy Rijo - 4/1/2014
Hi Charles,
Glad it helped out.
|