USP_DELETECMSCACHEITEMS

create procedure dbo.USP_DELETECMSCACHEITEMS
(
    @KEYS xml
)
as
begin
    set nocount on

    declare @KEYTABLE table (K nvarchar(255))
    insert into @KEYTABLE select KE.K.value('.', 'nvarchar(255)') from @KEYS.nodes('/keys/k') KE(K)

    delete dbo.CacheItems
    from dbo.Cacheitems CI
    inner join @KEYTABLE K on K.K = CI.[KEY]
end