Help with MSSQL Pivot Query

Transact-SQL
1

I received help with creating this pivot query below but im still missing something becuase the values are not pivoting , instead they are just showing up on the value name column

sql
sql.png1131×153 51 KB

SELECT * FROM (
SELECT
jD.AccountID,
SUM(jD.Amount) AS [Total Dollars],
COA.Name as COAName,
SUM(jD.Qty) AS QTY,
CONVERT(date, GETDATE()) AS Date,
AttributeDefinitions.Name,
AttributeValues.Value
FROM
AttributeDefinitions INNER JOIN
AttributeCategories ON AttributeDefinitions.AttributeCategoryID = AttributeCategories.AttributeCategoryID INNER JOIN
AttributeValues ON AttributeDefinitions.AttributeDefinitionID = AttributeValues.AttributeDefinitionID RIGHT OUTER JOIN
JnlDetails AS jD WITH (NOLOCK) INNER JOIN
COA ON jD.AccountID = COA.AccountID ON AttributeValues.AttributeValueGroupID = COA.AttributeValueGroupID
WHERE
(jD.CreateDate >= GETDATE() - 2) AND
(jD.CreateDate < GETDATE() + 1)
GROUP BY
jD.AccountID,
COA.Name,
jD.Qty,
jD.CreateDate,
AttributeDefinitions.Name,
AttributeValues.Value

) as T1
PIVOT
(
MAX([Name]) FOR Name IN ([ACCT_NO], [DEPT_ID], [GLENTRY_CLASSID],[GLENTRY_PROJECTID]
,[GLDIMBENEFITING_DEPARTMENT],[GLDIMFUND],[LOCATION_ID])
) PT

2

Change

PIVOT
(
MAX([Name]) FOR Name IN ([ACCT_NO], [DEPT_ID], [GLENTRY_CLASSID],[GLENTRY_PROJECTID]
,[GLDIMBENEFITING_DEPARTMENT],[GLDIMFUND],[LOCATION_ID])
) PT

INTO
PIVOT
(
MAX([Value]) FOR Name IN ([ACCT_NO], [DEPT_ID], [GLENTRY_CLASSID],[GLENTRY_PROJECTID]
,[GLDIMBENEFITING_DEPARTMENT],[GLDIMFUND],[LOCATION_ID])
) PT