sql math - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

sql math

Author

Topic

shelbyoh
Starting Member

14 Posts

Posted - 2011-02-28 : 13:56:07

I am looking to try to get the follow done.

I need to get the percentage of Total Number of Employees, percentage
Number of Minority Employees, Female Employees and Cleveland_Resident.

select top (1000) pj.ProjectName,b.BidPackageNumber, n.Date, 
SUM(n.MAF + n.MAM + n.MIF + n.MIM) as 'Total # Of Employee', 

SUM(n.MIM) as 'Minority Employees', SUM(n.MIF) as 'Female Employees', 

Case when  p.Cleveland_Resident = 1 then count(*)
else 0
end as 'Cleveland Residents' 

from Narrative n, PersonnelSummary p, Projects pj, BidPackage b
where n.Date between '2011-01-01' and '2011-01-31' and
n.Date = p.Date and n.Project_ID = p.Project_ID
and n.BidPackage_ID = p.BidPackage_ID
group by pj.ProjectName, b.BidPackageNumber, n.Date, p.Cleveland_Resident
order by pj.ProjectName, b.BidPackageNumber, n.Date

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources