Hi:
I have the following statement in t-sql:
SELECT A.LastName + ' , ' + A.FirstName AS Analyst, A.UID, M.LastName + ' , ' + M.FirstName AS Manager,
A.CCNum, TAS_TimeProdData.dtsDate,
Sum(CASE WHEN TAS_validTimeProdCodes.TPCode IS NOT NULL THEN TAS_TimeProdData.dblHours ELSE 0 END)
FROM (TAS_PeopleDynamic AS A INNER JOIN (TAS_TimeProdData INNER JOIN TAS_validTimeProdCodes ON TAS_TimeProdData.TPCodeID = TAS_validTimeProdCodes.TPCodeID)
ON A.UID = TAS_TimeProdData.UID) INNER JOIN TAS_PeopleDynamic AS M ON A.MgrUID = M.UID
GROUP BY A.LastName + ' , ' + A.FirstName, A.UID, M.LastName + ' , ' + M.FirstName, A.CCNum, TAS_TimeProdData.dtsDate
HAVING A.CCNum='1867' AND TAS_TimeProdData.dtsDate Between '1/1/04' And '1/1/04'
I need the to PIVOT by TAS_validTimeProdCodes.TPCode
so that it would look like this:
Analyst Manager CCNum dtsDate Category A Category B Category C and so on...
The hours to be listed beneath each category.
I do not know where to place this to do this.
Please help. Thanks
I have the following statement in t-sql:
SELECT A.LastName + ' , ' + A.FirstName AS Analyst, A.UID, M.LastName + ' , ' + M.FirstName AS Manager,
A.CCNum, TAS_TimeProdData.dtsDate,
Sum(CASE WHEN TAS_validTimeProdCodes.TPCode IS NOT NULL THEN TAS_TimeProdData.dblHours ELSE 0 END)
FROM (TAS_PeopleDynamic AS A INNER JOIN (TAS_TimeProdData INNER JOIN TAS_validTimeProdCodes ON TAS_TimeProdData.TPCodeID = TAS_validTimeProdCodes.TPCodeID)
ON A.UID = TAS_TimeProdData.UID) INNER JOIN TAS_PeopleDynamic AS M ON A.MgrUID = M.UID
GROUP BY A.LastName + ' , ' + A.FirstName, A.UID, M.LastName + ' , ' + M.FirstName, A.CCNum, TAS_TimeProdData.dtsDate
HAVING A.CCNum='1867' AND TAS_TimeProdData.dtsDate Between '1/1/04' And '1/1/04'
I need the to PIVOT by TAS_validTimeProdCodes.TPCode
so that it would look like this:
Analyst Manager CCNum dtsDate Category A Category B Category C and so on...
The hours to be listed beneath each category.
I do not know where to place this to do this.
Please help. Thanks