Thanks guys for all your help

ALTER PROCEDURE [dbo].[usp_PickHistoryReportTbl]

AS

BEGIN

TRUNCATE TABLE Tbl_PickHist;

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

SELECT * FROM...

Thank you!!!

I will look at changing it....

How can I cause it to perform every day? Is that just via a task in windows?

I thought that was a normal method... I don't know another answer..

Is that better as far as best practice?

This tells me incorrect syntax near MAX

I have SQL 2000 ... should...