DECLARE @tblTravelRecords table (
RequestID uniqueidentifier,
TravelNumber varchar(7),
EstimatedTravelCost decimal(11,2),
[status] int
)
INSERT INTO @tblTravelRecords
SELECT pol.RequestID
, pol.PONumber
, CAST( subtotal + pol.Shipping + IsNull(pol.Discount,0) + pol.SalesTax as decimal(11,2) ) as 'EstimatedTravelCost'
, pol.Status
FROM luPOStatus lu RIGHT JOIN (PurchaseOrderLog pol LEFT JOIN @tblPOsubtotal pod ON pol.RequestID=pod.RequestID) ON lu.StatusID=pol.Status
WHERE [Contract] = @Contract
AND TaskNumber = @TaskNumber
AND SubTask = @SubTask
AND ( UseFFPFunds <> 1 OR UseFFPFunds IS NULL )
No comments:
Post a Comment