pivot it to get data in desired format
select Classification,[Low],[Medium],[High],[Critical]
from
(
Select Incident_Number,Priority,Classification
From vars76_hpd_help_desk inner join
vTbl_Remedy_Group_Classification ON vARS76_HPD_Help_Desk.Assigned_Group = vTbl_Remedy_Group_Classification.Group_Name
where (status = 'Assigned' or status = 'New' or status = 'Pending' or status = 'in progress')
)t
PIVOT (COUNT(Incident_number) FOR Priority IN ([Low],[Medium],[High],[Critical]))p
ORDER BY Classification
for inserting above into table
just use
INSERT into table
above select statement
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Select Help
Posted - 08/10/2012 : 12:35:23
