[dbo].[MarkWebDealAsReprocessed]

BUILD09 > MoversSuite2 > Stored Procedures > dbo.MarkWebDealAsReprocessed

Properties
Parameters
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@inWebDealID	int	4

Permissions

Type	Action	Owning Principal
Grant	Execute	MssExec

SQL Script

/**
*
*    This procedure marks the specified PlasticWebDeal as having been reprocessed.
*
*    Input Parameters:
*    @param @inWebDealID        Primary key to a PlasticWebDeal instance.
*/
CREATE PROCEDURE [dbo].[MarkWebDealAsReprocessed]
    @inWebDealID int
as
set nocount on

update PlasticWebDeal set
    WasReprocessed = 1
where WebDealID = @inWebDealID
GO
GRANT EXECUTE ON  [dbo].[MarkWebDealAsReprocessed] TO [MssExec]
GO

Uses

[dbo].[PlasticWebDeal]
dbo