Declare @OrderType Varchar(Max) = 'Return' IF CHARINDEX ('Return',@OrderType)> 0 Begin Select Revenue * -1 & Cost * -1 ,Sales_Man,Order_Date,Order_Type From ERP_Source_Table END ELSE Begin Select Revenue - Cost From ERP_Source_Table END Select * from ERP_Source_Table
DECLARE @OrderType VARCHAR(MAX) = 'Returns' IF @OrderType = 'Success' SELECT Revenue - Cost FROM MyTable ELSE IF @OrderType = 'Return' SELECT Revenue * -1, Cost * -1 FROM MyTable ELSE SELECT * MyTable
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)