再所有字符串常量前加 NSELECT N'Chargeable Activities' AS Type, Projectname, ProjectID, SubmiterID, ProjectCode,
ProjectType, UserName, SUM(Duration) AS TotalDuration, ClientName
FROM vw_ChargeableUserReport
WHERE CAST(convert(char(10),EntryDate,120) as DATETIME) between '2002-04-14' and '2002-04-20' and DepartmentID = 1
GROUP BY Projectname, ProjectID, SubmiterID, ProjectCode, ProjectType, UserName, ClientName
UNION
SELECT N'Non-Chargeable Activities' AS Type, Projectname, ProjectID, SubmiterID, ProjectCode,
ProjectType, UserName, SUM(Duration) AS TotalDuration, ClientName
FROM vw_NonChargeableUserReport
WHERE CAST(convert(char(10),EntryDate,120) as DATETIME) between '2002-04-14' and '2002-04-20' and DepartmentID = 1
GROUP BY Projectname, ProjectID, SubmiterID, ProjectCode, ProjectType, UserName, ClientName
ProjectType, UserName, SUM(Duration) AS TotalDuration, ClientName
FROM vw_ChargeableUserReport
WHERE CAST(convert(char(10),EntryDate,120) as DATETIME) between '2002-04-14' and '2002-04-20' and DepartmentID = 1
GROUP BY Projectname, ProjectID, SubmiterID, ProjectCode, ProjectType, UserName, ClientName
UNION
SELECT N'Non-Chargeable Activities' AS Type, Projectname, ProjectID, SubmiterID, ProjectCode,
ProjectType, UserName, SUM(Duration) AS TotalDuration, ClientName
FROM vw_NonChargeableUserReport
WHERE CAST(convert(char(10),EntryDate,120) as DATETIME) between '2002-04-14' and '2002-04-20' and DepartmentID = 1
GROUP BY Projectname, ProjectID, SubmiterID, ProjectCode, ProjectType, UserName, ClientName
ProjectType, UserName, SUM(Duration) AS TotalDuration, ClientName
FROM vw_NonChargeableUserReport
WHERE CAST(convert(char(10),EntryDate,120) as DATETIME) between '2002-04-14' and '2002-04-20' and DepartmentID = 1
GROUP BY Projectname, ProjectID, SubmiterID, ProjectCode, ProjectType, UserName, ClientName
UNION
SELECT 'Chargeable Activities' AS Type, Projectname, ProjectID, SubmiterID, ProjectCode,
ProjectType, UserName, SUM(Duration) AS TotalDuration, ClientName
FROM vw_ChargeableUserReport
WHERE CAST(convert(char(10),EntryDate,120) as DATETIME) between '2002-04-14' and '2002-04-20' and DepartmentID = 1
GROUP BY Projectname, ProjectID, SubmiterID, ProjectCode, ProjectType, UserName, ClientName
SELECT 'Chargeable Activities' AS Type, Projectname, ProjectID, SubmiterID, ProjectCode,
ProjectType, UserName, SUM(Duration) AS TotalDuration, ClientName
FROM vw_ChargeableUserReport
WHERE CAST(convert(char(10),EntryDate,120) as DATETIME) between '2002-04-14' and '2002-04-20' and DepartmentID = 1
GROUP BY Projectname, ProjectID, SubmiterID, ProjectCode, ProjectType, UserName, ClientName
UNION all
SELECT 'Non-Chargeable Activities' AS Type, Projectname, ProjectID, SubmiterID, ProjectCode,
ProjectType, UserName, SUM(Duration) AS TotalDuration, ClientName
FROM vw_NonChargeableUserReport
WHERE CAST(convert(char(10),EntryDate,120) as DATETIME) between '2002-04-14' and '2002-04-20' and DepartmentID = 1
GROUP BY Projectname, ProjectID, SubmiterID, ProjectCode, ProjectType, UserName, ClientName