[dbo].[MssWebUpdateDocumentSendToCrew]

BUILD09 > MoversSuite2 > Stored Procedures > dbo.MssWebUpdateDocumentSendToCrew

Properties
Parameters
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@inOrderId	int	4
@inMssDocumentId	int	4
@inSendToCrew	bit	1

Permissions

Type	Action	Owning Principal
Grant	Execute	MssExec

SQL Script

CREATE PROCEDURE [dbo].[MssWebUpdateDocumentSendToCrew]
    @inOrderId int,
    @inMssDocumentId int,
    @inSendToCrew bit
AS
BEGIN
set nocount on

UPDATE MSSDocument SET
    SendToCrew = @inSendToCrew
WHERE MSSDocument.MSSDocumentID = @inMssDocumentId AND
    MSSDocument.OrderFID = @inOrderId

END
GO
GRANT EXECUTE ON  [dbo].[MssWebUpdateDocumentSendToCrew] TO [MssExec]
GO

Uses

[dbo].[MSSDocument]
dbo