USP_SEARCHLISTREPLACEMENTS_GETLIST

Returns a list of active search list replacements.

Definition

Copy


create procedure dbo.USP_SEARCHLISTREPLACEMENTS_GETLIST
as
begin

    select ID 'ORIGINALSEARCHLISTID'
        REPLACEMENTSEARCHLISTID
    from dbo.SEARCHLISTSETTINGS
    where not REPLACEMENTSEARCHLISTID is null
end