USP_SITEIMAGES_BULKAPPROVEIMAGES

CREATE procedure dbo.USP_SITEIMAGES_BULKAPPROVEIMAGES
(
    @XML xml,
    @NUMBERAPPROVED int = 0 output
)
AS    
BEGIN

set nocount on

    declare @SiteImageIDS table ([SiteImageID] int)
    insert into @SiteImageIDS select IDS.ID.value('.', 'int') from @XML.nodes('/SiteImages/id') IDS(ID)

    set @NUMBERAPPROVED = (select count(1)
    from dbo.SiteImages SP
    inner join @SiteImageIDS SPI on SPI.SiteImageID = SP.ID
    where SP.Approved <> 1)

    update dbo.SiteImages SET
    Approved=1
    from dbo.SiteImages SP
    inner join @SiteImageIDS SPI on SPI.SiteImageID = SP.ID

END