UFN_PROSPECTSEARCH_GET_MOSAICS

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTSEARCHID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PROSPECTSEARCH_GET_MOSAICS(@PROSPECTSEARCHID uniqueidentifier) 
            returns table
            as return
                select
                    ID,
          MOSAIC
                from
                    dbo.PROSPECTSEARCHMOSAIC
                where
                    PROSPECTSEARCHID = @PROSPECTSEARCHID;