CREATE OR ALTER PROCEDURE dbo.EmployeeGenderbyJobTitle
AS
BEGIN
SET NOCOUNT ON;
select Sum(case when e.Gender = 'M' then 1 end) as MaleEmployees
, Sum(case when e.Gender = 'F' then 1 end) as FemaleEmployees
, e.JobTitle
from humanresources.employee AS e
group by e.JobTitle
END
Not sure why you need the temp tables here in the first place. You could simplify this considerably with some conditional aggregation. This will return the count of gender by job title.
CREATE OR ALTER PROCEDURE dbo.EmployeeGenderbyJobTitle
AS
BEGIN
SET NOCOUNT ON;
select Sum(case when e.Gender = 'M' then 1 end) as MaleEmployees
, Sum(case when e.Gender = 'F' then 1 end) as FemaleEmployees
, e.JobTitle
from humanresources.employee AS e
group by e.JobTitle
END
发布评论
评论（2）
不知道为什么首先需要这里的临时表。您可以通过一些有条件的聚合可以大大简化这一点。这将通过职位返回性别计数。
Not sure why you need the temp tables here in the first place. You could simplify this considerably with some conditional aggregation. This will return the count of gender by job title.
go信号在sql Server中批量的末端，因此您不能在批处理中间使用GO功能等）参考
GOsignals the end of a batch in SQL Server so you can't usegoin middle of a batch (aprocedure,functionetc.)Reference SQL Server docs