USP_DATAFORMTEMPLATE_BATCHALERTBATCHSTATUS_VIEW

The load procedure used by the view dataform template "Batch Alerts Batch Status View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@BATCHNUMBER	nvarchar(100)	INOUT	Batch number
@BATCHTYPE	nvarchar(60)	INOUT	Batch type
@DESCRIPTION	nvarchar(1000)	INOUT	Description
@DATECHANGED	datetime	INOUT	Date changed
@STATUS	nvarchar(200)	INOUT	Status
@CATEGORY	nvarchar(100)	INOUT	Category
@COMMENTS	nvarchar(2000)	INOUT	Comments
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.

Definition

Copy



                create procedure dbo.USP_DATAFORMTEMPLATE_BATCHALERTBATCHSTATUS_VIEW (
                    @ID uniqueidentifier,
                    @BATCHNUMBER nvarchar(100) = null output,
                    @BATCHTYPE nvarchar(60) = null output,
                    @DESCRIPTION nvarchar(1000) = null output,
                    @DATECHANGED datetime = null output,
                    @STATUS nvarchar(200) = null output,
                    @CATEGORY nvarchar(100) = null output,
                    @COMMENTS nvarchar(2000) = null output,
                    @DATALOADED bit = 0 output
                ) as begin

                    select
                        @BATCHNUMBER = BATCH.BATCHNUMBER,
                        @BATCHTYPE = BATCHTYPECATALOG.NAME,
                        @DATECHANGED = BATCH.DATECHANGED,
                        @DESCRIPTION = BATCH.DESCRIPTION,
                        @STATUS = BATCHWORKFLOWSTATE.NAME,
                        @CATEGORY = BATCHTYPECATALOG.CATEGORY,
                        @COMMENTS = BATCH.COMMENTS,
                        @DATALOADED = 1
                    from
                        dbo.BATCH
                    left outer join
                        dbo.BATCHWORKFLOWSTATE on BATCH.BATCHWORKFLOWSTATEID = BATCHWORKFLOWSTATE.ID
                    left outer join
                        dbo.BATCHTEMPLATE on BATCH.BATCHTEMPLATEID = BATCHTEMPLATE.ID
                    left outer join
                        dbo.BATCHTYPECATALOG on BATCHTEMPLATE.BATCHTYPECATALOGID = BATCHTYPECATALOG.ID
                    where
                        BATCH.ID = @ID;

                    return 0;
                end