USP_DATAFORMTEMPLATE_VIEW_PROSPECTSEGMENTATIONSUMMARY

The load procedure used by the view dataform template "Prospect Segmentation Summary 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.
@SOURCETYPE	nvarchar(100)	INOUT	Prospect source
@SOURCENAME	nvarchar(100)	INOUT	Prospect source
@DESCRIPTION	nvarchar(255)	INOUT	Description
@OWNER	nvarchar(128)	INOUT	Owner
@DATEADDED	datetime	INOUT	Date added
@DATEUPDATED	datetime	INOUT	Date updated

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PROSPECTSEGMENTATIONSUMMARY (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @SOURCETYPE nvarchar(100) = null output,
          @SOURCENAME nvarchar(100)= null output,
                    @DESCRIPTION nvarchar(255) = null output,
                    @OWNER nvarchar(128) = null output,
                    @DATEADDED datetime = null output,
          @DATEUPDATED datetime = null output
                ) as
                    set nocount on;

                    select
                        @DATALOADED =  1,
            @SOURCETYPE=   case
                              when PROSPECTSEGMENTATION.RESEARCHGROUPID is not null then 1
                              when PROSPECTSEGMENTATION.IDSETREGISTERID is not null then 2 
                              else 0
                           end,
            @SOURCENAME =  case
                              when PROSPECTSEGMENTATION.RESEARCHGROUPID is not null then RESEARCHGROUP.NAME
                              when PROSPECTSEGMENTATION.IDSETREGISTERID is not null then IDSETREGISTER.NAME
                              else null
                           end,              
                        @DESCRIPTION = PROSPECTSEGMENTATION.DESCRIPTION,
                        @OWNER =       APPUSER.USERNAME,
                        @DATEADDED =   PROSPECTSEGMENTATION.DATEADDED,
            @DATEUPDATED = PROSPECTSEGMENTATION.DATEUPDATED
                    from
                        dbo.PROSPECTSEGMENTATION
                    left join dbo.APPUSER on 
            APPUSER.ID = PROSPECTSEGMENTATION.OWNERID
          left join dbo.RESEARCHGROUP on 
            RESEARCHGROUP.ID = PROSPECTSEGMENTATION.RESEARCHGROUPID
          left join dbo.IDSETREGISTER on 
            IDSETREGISTER.ID = PROSPECTSEGMENTATION.IDSETREGISTERID
                    where
                        PROSPECTSEGMENTATION.ID = @ID