USP_DATAFORMTEMPLATE_VIEW_PDACCOUNTSEGMENTMAPPEDRECORD

The load procedure used by the view dataform template "Account Segment Mapped Record View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@VALUE	nvarchar(255)	INOUT	Segment value
@SEGMENTMAPPINGID	uniqueidentifier	INOUT	SEGMENTMAPPINGID

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PDACCOUNTSEGMENTMAPPEDRECORD
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @VALUE nvarchar(255) = null output,
    @SEGMENTMAPPINGID uniqueidentifier = null output
)
as
    set nocount on;

    set @DATALOADED = 0;


    With MAPPING_CTE as 
    (select 
        0  as LOADED, 
        'Not Mapped'  as DESCRIP 

    union all

        select  
            1 as LOADED,
            T2.SHORTDESCRIPTION as DESCRIP
        from dbo.PDACCOUNTSEGMENTMAPPING T1
        inner join dbo.PDACCOUNTSEGMENTVALUE T2 on T1.PDACCOUNTSEGMENTVALUEID = T2.ID
            where T1.LONGDESCRIPTIONID = @ID and T1.LONGDESCRIPTIONID != ''
     )  

        select

            top 1 @VALUE = DESCRIP,
            @DATALOADED = 1
                    from
                        MAPPING_CTE C
                        order by LOADED DESC


    return 0;