P
Paul
One of the pages on my current project contains a simple status table that
shows whether an event has occurred or not. Currently it needs to be reset
to False at the start of each business day, then is manually flagged True
when the event occurs. The flag to True must remain manual because it is
never known when the event will happen. However it would be one less thing
to worry about when opening the store if it could be reset to False each
morning automatically.
I have never worked with Stored Procedures, and currently am managing the
SQL Server database through Access. I would appreciate some assistance both
in writing the procedure and figuring out how to trigger it at a specific
time (8:00 AM).
Here is what I have so far:
CREATE PROCEDURE dbo.ResetPickupFlag
AS
UPDATE Pickup SET PickupOccurred=False
GO
EXEC dbo.ResetPickupFlag
Currently, it returns the error "incorrect syntax near GO".
Any assistance you can provide would be appreciated.
Thanks.
Paul
shows whether an event has occurred or not. Currently it needs to be reset
to False at the start of each business day, then is manually flagged True
when the event occurs. The flag to True must remain manual because it is
never known when the event will happen. However it would be one less thing
to worry about when opening the store if it could be reset to False each
morning automatically.
I have never worked with Stored Procedures, and currently am managing the
SQL Server database through Access. I would appreciate some assistance both
in writing the procedure and figuring out how to trigger it at a specific
time (8:00 AM).
Here is what I have so far:
CREATE PROCEDURE dbo.ResetPickupFlag
AS
UPDATE Pickup SET PickupOccurred=False
GO
EXEC dbo.ResetPickupFlag
Currently, it returns the error "incorrect syntax near GO".
Any assistance you can provide would be appreciated.
Thanks.
Paul