Hello- The following code gives me the data I need, but now I need to get it into my VB.net code- can I call this as a SQL string right in the sub?
Or should it be a Stored Procedure and then called from the code, not sure of the best approach.
Thanks-
Code:
SELECT SUM(Quantity),
CASE Product
WHEN 'FIR-UPPERS' THEN 'MBF'
WHEN 'Nantucket Beadboard' THEN 'Truckload'
WHEN 'Plywood Treads and Risers' THEN 'Pallet'
WHEN 'Poplar and Oak Boards' THEN 'UNITS'
WHEN 'EWC Shingles' THEN 'SQUARES'
WHEN 'Unfinished Oak Flooring' THEN 'SQ FT'
WHEN 'WRC Shingles' THEN 'CARTONS'
END
FROM tblPoolinfo
Group by Product
Or should it be a Stored Procedure and then called from the code, not sure of the best approach.
Thanks-