Multiple case function in sqlserver - fabulouscode

Wednesday, December 1, 2021

Multiple case function in sqlserver





Example::::

SELECT GreyReceiveTypeName,

FROM TBL...XYZ

 CASE GreyReceiveTypeName WHEN 'Bulk' THEN 'Bulk' WHEN 'Sample' THEN 'Sample' WHEN 'Order Related Sample' THEN 'Sample' 

WHEN 'Others Sample' THEN 'Sample' WHEN 'RETURN' THEN 'RETURN' WHEN 'Replacement' THEN 'Replacement' WHEN 'Coller Cuff' THEN 'Coller Cuff' WHEN 'Coller Cuff' THEN 'Short Qty'

WHEN 'Process Loss Qty' THEN 'Process Loss Qty'  ELSE '' END ProductionType 

No comments:

Post a Comment

I am Safiqul Islam Tuhin