junk.mail291276 - Wednesday, March 7, 2018 7:42 AM
Thanks everyone,
Turns out this was causing the return of -1: SET NOCOUNT ON If I set NOCOUNT to OFF, it returns the number of rows.
Possibly a bad mistake especially if your app is relying on the single return of error number.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row. First step towards the paradigm shift of writing Set Based code: ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.