Hi all,
In Microsoft Headquarters we need to acknowledge worksheets after it has been processed correctly (that way it is archived). We have a lot of worksheets which are processed fine into the stores operation manager and needs to be acknowledged. To do this by hand will take a lot of time, so I wrote a SQL program which should be able to acknwledge a lot of worksheets within a few seconds. The only problem I have is that I am just starting with programming in SQL. Could someone tell me whether the program below is correct for acknowledging the worksheets, maybe I missed a few tables??. The only thing I know is missing is a user who is logged in Headquarters when using this program.
update worksheet set status = 6 where ID between 1 and 10000
Jeff2