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