USP_COPYSHAREDPART_UPDATE

create procedure dbo.USP_COPYSHAREDPART_UPDATE
(
    @SHAREDPARTID      int,
    @SELECTEDPARTID    varchar(1000)
)
as
begin
       Update PC Set PC.SiteContentID = @SHAREDPARTID
       From PageContent PC
            Inner Join dbo.UFN_STRING_PARSER(',', @SELECTEDPARTID) SP
                On PC.SiteContentID = SP.Item

    return 0;
end