ALTER PROCEDURE [dbo].[usp_PickHistoryReportTbl]

AS

BEGIN

TRUNCATE TABLE Tbl_PickHist;

INSERT INTO dbo.Tbl_PickHist (LastPick,ComponentItemNumber,IssuedQuantity)

SELECT * FROM S_PickHistory2

END

This works