Does sp_executesql return more than one row outputs.
I am having a issue with it:
my code is supposed to return 2 rows in the output but it is returning onyl one row(second row).
I guess, the first one is being overwritten by the second one. I am using sp_executesql because the sql string is being dynamically built.
the output is supposed to be like
instead it is showing like this
any idea on this?
View Complete Post