Enable Date Parameter in dynamic pivot table

Transact-SQL
1

DECLARE @DynamicPivotQuery AS NVARCHAR(MAX)
DECLARE @ColumnName AS NVARCHAR(MAX)
SELECT @ColumnName = ISNULL(@ColumnName + ',','')+ QUOTENAME(Descriptionitem) FROM (SELECT DISTINCT [Descriptionitem] FROM ItemMasterFile) AS [NAME]
DECLARE @ColumnForSum AS NVARCHAR(MAX)
SELECT @ColumnForSum = REPLACE(@ColumnName,',','+')
SELECT @ColumnForSum = REPLACE(@ColumnForSum,'[','ISNULL([')
SELECT @ColumnForSum = REPLACE(@ColumnForSum,']','],0)')

SET @DynamicPivotQuery = 'SELECT ROW_NUMBER() OVER (ORDER BY(SELECT 0)) IDwokrer
, PersonName,'+@ColumnName+'
,SUM('+@ColumnForSum+') Summa
FROM (
SELECT SUM(s.prdqty) Qty,p.Namworker as PersonName,f.Descriptionitem as Item
from Probale s
INNER JOIN Worker p ON s.IDwokrer= p.IDwokrer
INNER JOIN ItemMasterFile f ON s.Codeitem= f.Codeitem
GROUP BY p.Namworker ,f.Descriptionitem )t
pivot
(
MAX([Qty]) FOR Item IN ('+@ColumnName+')
) piv GROUP BY PersonName,'+@ColumnName+''
EXEC (@DynamicPivotQuery)

please guided

2

What's the error or why do you say it's not working, where is the date parameter

3

oh sorry,i want to enable date parameter for searching,i have another store procedure in which date parameter is not giving result as per my requirement,

above store procedure i want to date parameter to be enable,second thing is that null record should not display

4

First things first.

  1. Why are you declaring @ColumnName and checking to isnull on it?
  2. Why do you do a sub query to get description?
5

because i want description into column