spTransactions_MarkPollResultsAsProcessed
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PollID | int | IN |
Definition
Copy
CREATE procedure dbo.spTransactions_MarkPollResultsAsProcessed(@PollID int)
as
UPDATE dbo.SitePollResults
SET processed_date=getutcdate()
WHERE processed_date is null and
SitePollAnswersID IN ( SELECT ID FROM SitePollAnswers where SitePollsID = @PollID )