UFN_EVENTCONFLICT_GETADDEDBY

Returns a formatted string representing the user and date when the conflict was added.

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_EVENTCONFLICT_GETADDEDBY
            (
                @ID uniqueidentifier
            )
            returns nvarchar(100)
            with execute as caller
            begin 
                declare @RETVALUE nvarchar(100)

                select
                    @RETVALUE= CONVERT(CHAR(19),EVENTCONFLICT.DATEADDED,100)  
                from 
                    dbo.EVENTCONFLICT
                where 
                    ID=@ID
                group by SCHEDULEID,DATEADDED;

                return (@RETVALUE)
         end