USP_TASKREMINDERALERT_GETREMINDERS

create procedure dbo.USP_TASKREMINDERALERT_GETREMINDERS
as
begin
    set nocount on;

    select
        DATALISTCATALOG.ID as DATALISTID
        ,DATALISTCATALOG.TASKREMINDERDEFINITION.value(
            'DataListTaskReminderAlertType[1]/@ReminderTableName',
            'nvarchar(100)'
        ) as REMINDERTABLENAME
    from
        DATALISTCATALOG
    where
        (DATALISTCATALOG.TASKREMINDERDEFINITION is not null)
        and (len(convert(nvarchar(max), DATALISTCATALOG.TASKREMINDERDEFINITION)) > 0)

    return 0;
end