Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: I keep getting this error when running this script

    Thanks to all.

    I for got to add dbo.WipJobAllMat in the FROM

    CREATE PROC sp_UdateWipBinLocations

    AS

    Update dbo.WipJobAllMat

    Set dbo.WipJobAllMat.Bin = dbo.InvWarehouse.DefaultBin

    FROM dbo.InvWarehouse, dbo.WipJobAllMat

    INNER JOIN dbo.WipMaster ON dbo.WipJobAllMat.Job = dbo.WipMaster.Job

    Where dbo.InvWarehouse.StockCode = dbo.WipJobAllMat.StockCode

    and dbo.WipJobAllMat.Job...

  • RE: I keep getting this error when running this script

    I really appreciate the help on this I am being split between one Division and another and trying to pull TSQL from the back of my brain from College while...

Viewing 2 posts - 1 through 2 (of 2 total)