USP_SITECONTENT_BULKDELETE

CREATE procedure dbo.USP_SITECONTENT_BULKDELETE(@XML xml)
AS        
    BEGIN TRAN        
    set nocount on
    declare @SiteContentIDS table ([ID] int)

    insert into @SiteContentIDS select IDS.ID.value('.', 'int') from @XML.nodes('/SiteContent/id') IDS(ID)

    delete CMSEVERYONESECURITYPRIVS from dbo.CMSEVERYONESECURITYPRIVS inner join dbo.SITECONTENT on CMSEVERYONESECURITYPRIVS.SECUREDOBJECTGUID = SITECONTENT.Guid
    inner join @SiteContentIDS SC on SC.ID=SITECONTENT.ID

    delete CMSOBJETSECURITYEXCEPTION from dbo.CMSOBJETSECURITYEXCEPTION inner join dbo.SITECONTENT on CMSOBJETSECURITYEXCEPTION.SECUREDOBJECTGUID = SITECONTENT.Guid
    inner join @SiteContentIDS SC on SC.ID=SITECONTENT.ID

    delete SITECONTENTTAG from dbo.SITECONTENTTAG inner join @SiteContentIDS SC on SC.ID=SITECONTENTTAG.SITECONTENTID

    delete SEARCH from dbo.SEARCH inner join @SiteContentIDS SC on SEARCH.SiteContentID=SC.ID 

    delete PersonalizedContentData FROM dbo.PersonalizedContentData inner join @SiteContentIDS SC on PersonalizedContentData.SiteContentID=SC.ID 

    update SITECONTENT set INTRASHBIN=0 from dbo.SITECONTENT inner join @SiteContentIDS SC on SiteContent.ID=SC.ID
    COMMIT TRAN