Multiple Case Statments

How do i add multiple case statements


CREATE procedure rpt_blankregistrationquestions

@cmb1 as varchar(100),

@cmb2 as varchar(100) WITH ENCRYPTION

AS

BEGIN

SELECT DISTINCT

Child.surname + ', ' + Child.forename AS ChildName,

permissionRequired.description,

healthitems.description,

dietaryneeds.description,




CASE WHEN permissionRequired.active = 1 THEN 'YES'


WHEN permissionRequired.active = 0 THEN 'NO'

END AS Child_Permission


CASE WHEN healthitems.description.active = 1 THEN 'YES'


WHEN healthitems.description.active = 0 THEN 'NO'

END AS Health_Permission


CASE WHEN dietaryneeds.description.active = 1 THEN 'YES'


WHEN dietaryneeds.description.active = 0 THEN 'NO'

END AS Dietaryneeds_Permission


FROM healthItems CROSS JOIN

DietaryNeeds CROSS JOIN

permissionRequired CROSS JOIN

Child


ORDER BY ChildName

END