It seems that Row_num() function does not works with Dynamic sql having if
blocks to check input parameters for null and sp_executesql t excute the
query...Please help me to find a necesasry solution..
Hari
Can yopu post sample data + an expected result to be tested?
"Hari" <Hari@.discussions.microsoft.com> wrote in message
news:8CE0B2A3-4347-4983-BD35-A2B502BFFD8D@.microsoft.com...
> It seems that Row_num() function does not works with Dynamic sql having if
> blocks to check input parameters for null and sp_executesql t excute the
> query...Please help me to find a necesasry solution..
No comments:
Post a Comment