USP_DATAFORMTEMPLATE_VIEW_DATATUNEUP

The load procedure used by the view dataform template "Data Tune-Up Page Expression View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@DATATUNEUPID	uniqueidentifier	INOUT	Data tune-up ID
@COAUPDATEID	uniqueidentifier	INOUT	Change of address ID
@ADDRESSVALIDATIONID	uniqueidentifier	INOUT	Address validation ID
@EMAILFINDERID	uniqueidentifier	INOUT	EMAILFINDERID
@PHONEFINDERID	uniqueidentifier	INOUT	PHONEFINDERID
@PEOPLEFINDERID	uniqueidentifier	INOUT	PEOPLEFINDERID
@DECEASEDFINDERID	uniqueidentifier	INOUT	DECEASEDFINDERID

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DATATUNEUP
                (
                    @DATALOADED bit = 0 output,
                    @DATATUNEUPID uniqueidentifier = null output,
                    @COAUPDATEID uniqueidentifier = null output,
                    @ADDRESSVALIDATIONID uniqueidentifier = null output,
                    @EMAILFINDERID uniqueidentifier = null output,
                    @PHONEFINDERID uniqueidentifier = null output,
                    @PEOPLEFINDERID uniqueidentifier = null output,
                    @DECEASEDFINDERID uniqueidentifier = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select top (1)
                        @DATALOADED = 1,
                        @DATATUNEUPID = DATATUNEUP.ID
                    from
                        dbo.DATATUNEUP
                    order by
                        DATATUNEUP.DATEADDED;

                    select 
                        @COAUPDATEID = COAUPDATE.ID
                    from dbo.COAUPDATE
                    where DATATUNEUPID = @DATATUNEUPID

                    select 
                        @ADDRESSVALIDATIONID = ADDRESSVALIDATION.ID
                    from dbo.ADDRESSVALIDATION
                    where DATATUNEUPID = @DATATUNEUPID

                    select top(1)
                        @EMAILFINDERID = ID
                    from
                        dbo.EMAILFINDER
                    where
                        SITEID is null

                    select top(1)
                        @PEOPLEFINDERID = ID
                    from
                        dbo.PEOPLEFINDER
                    where
                        SITEID is null

                    select top(1)
                        @PHONEFINDERID = PHONEFINDER.[ID]
                    from
                        dbo.PHONEFINDER
                    where
                        PHONEFINDER.[SITEID] is null;

                    select top(1)
                        @DECEASEDFINDERID = ID
                    from
                        dbo.DECEASEDFINDER
                    where
                        SITEID is null

                    return 0;