Avatar of iscivanomar
Flag for United States of America

asked on 

How could I insert data into a temp table that is coming back from a Stored Procedure?

I have the Insert Into  before the I call the stored Procedure. The parameters with the values are coming back but the table does not get updated.
                        INSERT INTO @BestMoveFromTo (LocationFromName ,LocationToName, OccupiedPos, Capacity, NumberOfMoves, NumberofFreeSpaces, Percentage)

                        EXEC [WMS.Handling].[GetPalletMoveEfficiency] @LocationFromName ,@LocationToName, @OccupiedPos OUT,      @Capacity OUT,
                              @NumberOfMoves OUT, @NumberofFreeSpaces OUT, @Percentage OUT      
Thank you
Microsoft SQL Server 2008Microsoft SQL Server 2005

Avatar of undefined
Last Comment

8/22/2022 - Mon