Select Data Using Pivot methd

• dilip.aim11

  SSChasing Mays

  Points: 604

  More actions

  May 25, 2012 at 4:17 am

  #1493030

  hi ..

  i solved my self

  Declare @Date as DateTime = '03/01/2012'

  Declare @Columns as Varchar(100) = '['+CAST(@Date as Varchar)+']' + ',' +'['+ CAST( dateadd(day,1,@Date) as Varchar) +']'

  print @columns

  DECLARE @query VARCHAR(8000)

  SET @query = '

  SELECT nominalid,'+@Columns+'

  FROM

  (select nominalid,amount,[date] from tbl_Deposit )up

  PIVOT

  (

  SUM(amount)

  FOR [date]

  IN (' + @Columns + ')

  )

  AS p order by nominalid'

  print @query

  EXECUTE(@query)

  Thanks