USP_DATAFORMTEMPLATE_VIEW_ORGUNITSPAGEEXPRESSION

The load procedure used by the view dataform template "Organizational Units Summary Page Expression Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NUMUNITS	int	INOUT	NUMUNITS
@TOPORGUNITID	uniqueidentifier	INOUT	TOPORGUNITID
@TOPORGUNITNAME	nvarchar(64)	INOUT	TOPORGUNITNAME

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_ORGUNITSPAGEEXPRESSION
    (
    @DATALOADED bit = 0 output,
    @NUMUNITS integer = null output, 
    @TOPORGUNITID uniqueidentifier = null output,
    @TOPORGUNITNAME nvarchar(64) = null output
    )
as
begin
    set nocount on;

    set @DATALOADED = 1;

    select 
        @NUMUNITS = count(ADORGANIZATIONALUNIT.ID)
    from
        dbo.ADORGANIZATIONALUNIT;


    if @NUMUNITS > 0
        select top 1
            @TOPORGUNITID = ADORGANIZATIONALUNIT.ID, 
            @TOPORGUNITNAME = ADORGANIZATIONALUNIT.NAME
        from 
            dbo.ADORGANIZATIONALUNIT
        order by
            ADORGANIZATIONALUNIT.DATEADDED;

    return 0;
end