Comments by Member 12750150 (Top 1 by date)

Solution 3 worked like a charm. Simple syntax adjustment in my stored procedure solved the problem. I had tried ExecuteScalar with my previous syntax and it didn't work either. Didn't test it, but Solution 2 looks like a variation on the same theme as Solution 3. Thanks, Karthik.