Multiple Update, Several Where criteria

Question

 

Im sorry if this has been covered, I tried a search but I couldnt seem to find what I was after.

 

Anyway, I need an Update procedure which is actually several bunched into one. Ive had a stab at it myself, and perhaps my pseudo SQL might explain what I need..

 

Code Block

UPDATE [TW].[dbo].[TBLSalesPart]

SET

CASE WHEN [Part] = 'MONTV-' AND [YN] = 'False' THEN [SubCategory] = 20440 END

CASE WHEN [Part] = 'TC-' AND [YN] = 'False' THEN [SubCategory] = 20444 END

 

 

 

Hopefully this makes sense, cheers..

Answer 1

Here it is:

UPDATE [TW].[dbo].[TBLSalesPart]
SET [SubCategory] = 20440 WHERE [Part] = 'MONTV-' AND [YN] = 'False';

UPDATE [TW].[dbo].[TBLSalesPart]
SET [SubCategory] = 20444 WHERE [Part] = 'TC-' AND [YN] = 'False';


Put it in a tansaction if you need.

Thanks,
Zuomin

Answer 2

UPDATE [TW].[dbo].[TBLSalesPart]

SET [SubCategory]=CASE

WHEN [Part] = 'MONTV-' AND [YN] = 'False' THEN 20440

WHEN [Part] = 'TC-' AND [YN] = 'False'  Then 20444

END

 

check this

 

Madhu

 

Answer 3

thanks guys excatly what I needed