create table #buchedata(fonhand int, fqtyinspec int, fonorder int,
fproqty int, fbook int, fnonnetqty int, fmeasure char)
insert into #buchedata
select 4300,85,0,4,0,63,'EA' union
select 10452,0,1,4,0,56,'LBS' union
select 56326,0,2,85,0,44,'EA' union
select 52,0,1,4,0,13,'LBS' union
select 685,5,0,445,0,76,'EA '
if you run this:
CONVERT(DECIMAL(10,2),(fonhand + fqtyinspec + fonorder) - (fproqty + fbook + fnonnetqty)), + fmeasure as [Avail],
fmeasure as [U/M]
i'd want to output to be
not the QTY and fmeasure in separate columns
Hope that makes sense.