as_nt_processNotifications

CREATE PROCEDURE [dbo].[as_nt_processNotifications]
   @ids nvarchar(512),
    @username nvarchar(128)
AS
BEGIN
    update as_nt_notifications
    set processed=1, processedDate=getdate()
    where [to]= @username and ( @ids ='' or  id in(select Value from dbo.split(@ids, ',')))
        and (processed is null or processed =0)
    select 1
END