USP_SEARCHLIST_GETMETADATA_FORSEARCHEXECUTION

create procedure dbo.USP_SEARCHLIST_GETMETADATA_FORSEARCHEXECUTION(@ID uniqueidentifier)
as begin
    select 
        FILTERFORMDEFINITION,
        OUTPUTDEFINITION,
        STATICPARAMETERDEFINITION,
        IMPLEMENTATIONTYPE as SEARCHLISTTYPE,
        PROCEDURENAME,
        ASSEMBLYNAME,
        CLASSNAME
    from
        dbo.SEARCHLISTCATALOG         
    where
        SEARCHLISTCATALOG.ID = @ID

    return 0
end