Hi All,
I have a table named tbl which contains 250 rows
I have a Varaible @CNT = SELECT count(*) from tbl
Then i have a query as Select top 10 * from tbl
Now i want to pass @CNT into second query.
The output of Select top 10 * from tbl will be
1val1
2val2
..
..
..
10val 10
But i want as
1val1250
2val2250
..
..
..
10val 10250
250 indicates the value of @CNT.
Or is there any other way in which i can pass @CNT as a seperate field in SQL Server Reporitng Services RDL
Thanks in advance