SQL program acknowledging worksheets

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

Reply to
Jeff
Loading thread data ...

Jeff,

You only need to acknowledge the worksheet that is processed already not all !!!

"Jeff" wrote:

Reply to
GregDxb

Thanks Greg for the response, indeed this is the line I needed to acknowledge them without giving a range. I think that, where status = 2 should be where status = 4 because status 2 is approved for processing and status 4 is succesfully processed. This will save us a lot of time concerning the acknowledging process.

Jeff2

"GregDxb" wrote:

Reply to
Jeff

Reply to
GregDxb

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.