SQL SERVER||Stored Procedure to get Gender count from a table

Опубликовано: 11 Октябрь 2024
на канале: LearnSQLtoSSIS

131

Stored Procedure to get gender count from a table

ALTER Procedure GetGenderCount
@gender nchar(1),
@gendernew nchar(1)
AS
SELECT SUM(CASE WHEN gender='M' THEN 1 ELSE 0 END) AS Male_Count
,SUM(CASE WHEN gender='F' THEN 1 ELSE 0 END) AS Female_Count
FROM [Persondata$]
WHERE gender = @gender OR gender = @gendernew
GROUP BY gender

EXEC GetGenderCount M,F