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