Fixed Query - Not returning selected statement with exec SP
Something strange happening with my query template, not sure why. I guess i am missing something here.
SP with following logic:
Set @a = (Select.....);
Select B from xyz;
In SQL QT with fixed mode:
I am not able to see result of Select B from.....query, it just gives me a blank Rowsets node. Any pointers??
Thanks in advance.