InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 16:04:44 GMT20http://www.sqlservercentral.com/Forums/Topic1420029-338-1.aspxThanks a lot Anthony. This helped me to fix the issue with which i was strugglingThu, 14 Feb 2013 07:11:00 GMTjeganbenitto.francishttp://www.sqlservercentral.com/Forums/Topic1420029-338-1.aspxneeds to be done in the same session but dodeclare @cnt intselect @cnt = count(*) from tableselect top 10 *, @cnt from tableThu, 14 Feb 2013 06:51:33 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1420029-338-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 tbl Now 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 06:48:06 GMTjeganbenitto.francis