InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 16:59:57 GMT20http://www.sqlservercentral.com/Forums/Topic1419978-1063-1.aspxHi All,I have a table named tbl which contains 250 rowsI have a Varaible @CNT = SELECT count(*) from tblThen i have a query as Select top 10 * from tblNow i want to pass @CNT into second query. The output of Select top 10 * from tbl will be1 val12 val2. .. .. .10 val 10But i want as 1 val1 250 2 val2 250. .. .. .10 val 10 250 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 RDLThanks in advanceThu, 14 Feb 2013 04:43:13 GMTjeganbenitto.francis