USP_DATAFORMTEMPLATE_VIEW_SCHOOLISSINGLE

The load procedure used by the view dataform template "School is single view"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@SCHOOLID	uniqueidentifier	INOUT	SCHOOLID
@SCHOOLNAME	nvarchar(100)	INOUT	SCHOOLNAME
@ISSINGLESCHOOL	bit	INOUT	ISSINGLESCHOOL

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_SCHOOLISSINGLE
(
    @DATALOADED bit = 0 output,
    @SCHOOLID uniqueidentifier = null output,
    @SCHOOLNAME nvarchar(100) = null output,
    @ISSINGLESCHOOL bit = null output
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows

    set @DATALOADED = 1;

    select @ISSINGLESCHOOL = dbo.UFN_SCHOOL_ISSINGLESCHOOL()

    if (@ISSINGLESCHOOL <> 0)
    begin
        select
            @SCHOOLNAME = NAME,
            @SCHOOLID = SCHOOL.ID
        from dbo.SCHOOL
            inner join dbo.CONSTITUENT on SCHOOL.ID = CONSTITUENT.ID
    end

    return 0;