USP_BUSINESSPROCESSVIEW_ADDVIEW

Parameters

Parameter	Parameter Type	Mode
@BUSINESSPROCESSID	uniqueidentifier	IN
@QUERYVIEWID	uniqueidentifier	IN
@CAPTION	nvarchar(255)	IN
@JOINFIELD	nvarchar(128)	IN
@CHANGEAGENTID	uniqueidentifier	IN
Definition

Copy


            create procedure dbo.USP_BUSINESSPROCESSVIEW_ADDVIEW
                @BUSINESSPROCESSID uniqueidentifier,
                @QUERYVIEWID uniqueidentifier,
                @CAPTION nvarchar(255),                
                @JOINFIELD nvarchar(128),
                @CHANGEAGENTID uniqueidentifier
            with execute as caller                
            as
            begin
                set nocount on

                declare @ID uniqueidentifier

                select 
                    @ID = ID 
                from 
                    dbo.BUSINESSPROCESSVIEW 
                where 
                    BUSINESSPROCESSCATALOGID = @BUSINESSPROCESSID and
                    QUERYVIEWCATALOGID = @QUERYVIEWID

                declare @CurrentDate datetime
                set @CurrentDate = GetDate()

                if @CHANGEAGENTID is null                    
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;                    

                if @ID is null
                    begin
                        set @ID = newid()

                        insert into dbo.BUSINESSPROCESSVIEW
                            (ID, BUSINESSPROCESSCATALOGID, QUERYVIEWCATALOGID, CAPTION, JOINFIELD, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                        values
                            (@ID, @BUSINESSPROCESSID, @QUERYVIEWID, @CAPTION, @JOINFIELD, @CHANGEAGENTID, @CHANGEAGENTID, @CurrentDate, @CurrentDate)                                                                                        
                    end
                else
                    begin
                        update 
                            dbo.BUSINESSPROCESSVIEW
                        set
                            CAPTION = @CAPTION,
                            JOINFIELD = @JOINFIELD,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CurrentDate    
                        where
                            ID = @ID
                    end
            end