UFN_PROSPECT_GETPROSPECTPLANSTATUSES

Gets a textual list of a prospect's plans and the status of each.

Return

Return Type
nvarchar(200)

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PROSPECT_GETPROSPECTPLANSTATUSES(@PROSPECTID uniqueidentifier) 
            returns nvarchar(200)
            with execute as caller
            as begin
                declare @LIST as nvarchar(200)
                set @LIST = ''
                select 
                    @LIST = @LIST + dbo.UFN_PROSPECTPLANTYPECODE_GETDESCRIPTION(L.PROSPECTPLANTYPECODEID) + ' - ' + dbo.UFN_PROSPECTPLANSTATUSCODE_GETDESCRIPTION(L.PROSPECTPLANSTATUSCODEID) + nchar(13)
                from
                    dbo.PROSPECTPLAN L
                where
                    L.PROSPECTID=@PROSPECTID
                return @LIST
            end