I have a store proc that contains a column called "Pallet_Amt". I need to create another column that will display the type of Pallet_Amt.
Pallet_Amt = sum(isnull(CASE
** WHEN ISNULL(od.Balance_Qty,0) > 0 and ISNULL(iplc.Per_Container_Qty,0) > 0 and ISNULL(iplc.Container_Volume,0) > 0 THEN ((od.Balance_Qty / iplc.Per_Container_Qty) * iplc.Container_Volume) / @cubicMeterPallet**
** ELSE 0**
New column base off of the Pallet_Amt
WHEN Pallet_Amt < .75 THEN "GRND"
WHEN Pallet_Amt >= .75 THEN "LTL"
How can I do this without creating a temp file.