UFN_SITEID_MAPFROM_PROSPECTRESEARCHREQUESTID

Maps a PROSPECTRESEARCHREQUESTID to a SITEID

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTRESEARCHREQUESTID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_SITEID_MAPFROM_PROSPECTRESEARCHREQUESTID
            (
                @PROSPECTRESEARCHREQUESTID uniqueidentifier
            )
            returns table
            as
            return
            (
                select SITEID 
                from dbo.PROSPECTRESEARCHREQUEST PRR
                left join dbo.PROSPECTRESEARCHREQUESTSITE PRS on PRS.PROSPECTRESEARCHREQUESTID = PRR.ID
                where PRR.ID = @PROSPECTRESEARCHREQUESTID
            );