a guest Jun 25th, 2019 51 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- WITH PRODUCTION_CTE(ShortProdNo,BoatRefNumber,ProdNo, CustomerPoNumber,LoadDate, Trailer, VeadaBuilding)
- FBS.BoatNumber AS ShortProdNo,
- UOD..BoatRefNumber AS BoatRefNumber,
- FBS.ProdNo AS ProdNo,
- UOD.CustomerPoNumber AS CustomerPoNumber,
- FBS.Shipped AS LoadDate,
- FBS.TruckNum AS Trailer,
- WHEN Rtrim(UOD.CustomerPoNumber)='VEADA-VS1' THEN 'Bldg10'
- ELSE 'Bldg4'
- END) AS VeadaBuilding
- FROM SysproCompanyV.dbo.FlatBenningtonShipping as FBS
- INNER JOIN SysproCompanyV.dbo.UsrOrderDetails as UOD
- ON FBS.BoatNumber=UOD.BoatRefNumber)
- Msg 102, Level 15, State 1, Line 17
- Incorrect syntax near ')'.
RAW Paste Data