USP_BBITEMPLATETOOL_BBITEMPLATEREVIEW_VIEW

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@BBITEMPLATEID	uniqueidentifier	INOUT
@PASSED	bit	INOUT
@NOTES	nvarchar(max)	INOUT
@REVIEWERID	uniqueidentifier	INOUT
@REVIEWDATE	date	INOUT
@DATALOADED	bit	INOUT

Definition

Copy



            create procedure dbo.USP_BBITEMPLATETOOL_BBITEMPLATEREVIEW_VIEW
                (
                                @ID uniqueidentifier,
                                @BBITEMPLATEID uniqueidentifier = null output,
                                @PASSED bit = null  output,
                                @NOTES nvarchar(max) = null  output,
                                @REVIEWERID uniqueidentifier = null  output,
                                @REVIEWDATE date = null  output,
                                @DATALOADED bit = 0 output
                            )
                            as
            begin
                    set nocount on;
                                select
                                    @BBITEMPLATEID = tr.BBITEMPLATEID,
                                    @PASSED = tr.PASSED,
                                    @NOTES = tr.NOTES,
                                    @REVIEWERID = tr.REVIEWERID,
                                    @REVIEWDATE = tr.REVIEWDATE,
                                    @DATALOADED = 1

                                from
                                    dbo.BBITemplateReview tr
                                where
                                    tr.ID = @ID
            end