Plz Help

Here is my dynamic pivot table, how can I do group by

DECLARE

@DynamicPivotQueryASNVARCHAR(MAX)

DECLARE

@ColumnNameASNVARCHAR(MAX)

SELECT

@ColumnName=ISNULL(@ColumnName+',','')

      

+QUOTENAME(name)

FROM

(SELECTDISTINCTnameFROM#tmpBusdatewise)ASname

SET

@DynamicPivotQuery=

 

N'SELECT datewise, '+@ColumnName+'

    FROM #tmpBusdatewise

    PIVOT(SUM(totlcnt)

          FOR name IN ('

+@ColumnName+') ) AS PVTTable'-- group by ' + @columnname

Thanks

Samir

EXEC

sp_executesql@DynamicPivotQuery

Could you please explain what are you looking for? 

thanks , now it is solved.

actualy counting was not hapning

I added

---------------------

DECLARE

@DynamicPivotQueryASNVARCHAR(MAX)

DECLARE

@ColumnNameASNVARCHAR(MAX)

declare

@colmnasnvarchar(max)

SELECT

@colmn=ISNULL(@colmn+',','')

      

+'sum('+QUOTENAME(name)+') as '+QUOTENAME(name)

FROM

(SELECTDISTINCTnameFROM#tmpBusdatewise)ASname

SELECT

@ColumnName=ISNULL(@ColumnName+',','')

      

+QUOTENAME(name)

FROM

(SELECTDISTINCTnameFROM#tmpBusdatewise)ASname

SET

@DynamicPivotQuery=

 

N'SELECT datewise, '+@colmn+'

    FROM #tmpBusdatewise

    PIVOT(SUM(totlcnt)

          FOR name IN ('

+@ColumnName+') ) AS PVTTable group by datewise'

--print(@DynamicPivotQuery)

EXEC

sp_executesql@DynamicPivotQuery

• Marked as answer by ShankarSamir 25 minutes ago