I am trying to figure out how to use these CASE statements.
I have a Stored Procedure that is capturing some incorrect data.
I need to to filter out base on 2 criteria:
If USCATVLS_1 = "Latitude" then USCATVLS_2 = "Hum. Stem"
else
If USCATVLS_1 = "RHS" then USCATVLS_2 = "Rad. Stem"
else
IV00101.USCATVLS_2 in ('Elbow','Femur','Glenoid','Great Toe','Hum. Stem','Lesser Toe','PLATE','Plug','Prime Pin','Prm Screw','Prox Screw','Rad. Stem','RES. HEAD','Staple','SubTalar','Surg. Pack','Talar','Wedge')
I tried to make a CASE statement, but I dont know how to use the list of values at the end, it only wants me to use one.
Any Help?
I am using SQL 2005
I have a Stored Procedure that is capturing some incorrect data.
I need to to filter out base on 2 criteria:
If USCATVLS_1 = "Latitude" then USCATVLS_2 = "Hum. Stem"
else
If USCATVLS_1 = "RHS" then USCATVLS_2 = "Rad. Stem"
else
IV00101.USCATVLS_2 in ('Elbow','Femur','Glenoid','Great Toe','Hum. Stem','Lesser Toe','PLATE','Plug','Prime Pin','Prm Screw','Prox Screw','Rad. Stem','RES. HEAD','Staple','SubTalar','Surg. Pack','Talar','Wedge')
I tried to make a CASE statement, but I dont know how to use the list of values at the end, it only wants me to use one.
Any Help?
I am using SQL 2005