USP_DATALIST_CMSBBPAY_CONTENTNEEDINGUPDATE

CREATE procedure dbo.USP_DATALIST_CMSBBPAY_CONTENTNEEDINGUPDATE
(
    @FORCEUPDATE bit = 0
)
as
    set nocount on;

    declare @content table (
        SITECONTENTID int,
        SITEPAGEID int,
        DELIVERYCHANNELID uniqueidentifier);

    insert into @content
    select
        SITECONTENTID,
        SITEPAGEID,
        DELIVERYCHANNELID
    from 
        dbo.UFN_CMS_BBPAY_CONTENTNEEDINGUPDATE_DELIVERYCHANNEL(@FORCEUPDATE)

    select
        SITECONTENTID,
        SITEPAGEID,
        PageName,
        DELIVERYCHANNELID
    from 
        @content c
        join dbo.SitePages on SitePages.ID = c.SITEPAGEID AND SitePages.Deleted=0