UFN_NFGCAMPAIGNLEVEL_GETSITES

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@NFGCAMPAIGNLEVELID	uniqueidentifier	IN

Definition

Copy



      create function dbo.UFN_NFGCAMPAIGNLEVEL_GETSITES
      (
                @NFGCAMPAIGNLEVELID uniqueidentifier
            )
            returns table
            as
            return
            (
                select ID,
        SITEID
                from 
                    dbo.FAFNFGCAMPAIGNLEVELDISPLAYSITE
                where 
                    FAFNFGCAMPAIGNLEVELDISPLAYSITE.NFGCAMPAIGNLEVELID = @NFGCAMPAIGNLEVELID
            )