SELECT
CASE (SELECT DISTINCT itemname from ICISDataDB_E.dbo.dim_VitalSignItem vs where vs.itemno=V.ItemNo) AS CASE (SELECT DISTINCT itemname fro
SELECT
CASE (SELECT DISTINCT itemname from ICISDataDB_E.dbo.dim_VitalSignItem vs where vs.itemno=V.ItemNo) AS CASE (SELECT DISTINCT itemname fro