Output of Dynamic variable to next query

• jeganbenitto.francis

  SSC Eights!

  Points: 956

  More actions

  February 14, 2013 at 6:48 am

  #394184

  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

• Ant-Green

  SSC Guru

  Points: 113536

  More actions

  February 14, 2013 at 6:51 am

  #1587892

  needs to be done in the same session but do

  declare @cnt int

  select @cnt = count(*) from table

  select top 10 *, @cnt from table

• jeganbenitto.francis

  SSC Eights!

  Points: 956

  More actions

  February 14, 2013 at 7:11 am

  #1587907

  Thanks a lot Anthony. This helped me to fix the issue with which i was struggling