*Hi All,* *for below query i'm trying to add another column called "Percentage(%)"*
*here Percentage Criteria = ((Failed count*100)/Accepted)* *Any help...* *SELECT TOP (100) PERCENT DATEADD(week, DATEDIFF(week, 0, derivedtbl_1.LastStatusTime), 0) AS [WEEK (Date)], * * SUM(CASE LastStateName WHEN 'Failed' THEN 1 ELSE 0 END) AS [Failed Count], SUM(CASE LastacceptanceStateName WHEN 'Accepted' THEN 1 ELSE 0 END) * * AS Accepted, SUM(CASE LastStateName WHEN 'Succeeded' THEN 1 ELSE 0 END) AS Succeeded, dbo.v_Package.Name <http://dbo.v_Package.Name> AS [Package Name], * * dbo.v_Advertisement.AdvertisementID* *FROM (SELECT TOP (100) PERCENT ResourceID, MAX(LastStatusTime) AS LastStatusTime, AdvertisementID, LastStateName, LastAcceptanceStateName* * FROM dbo.v_ClientAdvertisementStatus* * GROUP BY ResourceID, AdvertisementID, LastStateName, LastAcceptanceStateName* * HAVING (LastStateName = 'Failed' OR* * LastStateName = 'Succeeded' OR* * LastAcceptanceStateName = 'Accepted') AND (MAX(LastStatusTime) >= CONVERT(DATETIME, '2014-03-10', 102))) AS derivedtbl_1 INNER JOIN* * dbo.v_Advertisement ON derivedtbl_1.AdvertisementID = dbo.v_Advertisement.AdvertisementID INNER JOIN* * dbo.v_Package ON dbo.v_Advertisement.PackageID = dbo.v_Package.PackageID* *GROUP BY DATEADD(week, DATEDIFF(week, 0, derivedtbl_1.LastStatusTime), 0), dbo.v_Package.Name <http://dbo.v_Package.Name>, dbo.v_Advertisement.AdvertisementName, * * dbo.v_Advertisement.AdvertisementID*
