USP_SMARTQUERY_GETMETADATA_FORQUERYPROMPT

        create procedure dbo.USP_SMARTQUERY_GETMETADATA_FORQUERYPROMPT (
            @ID uniqueidentifier)

        as

            select 
            FILTERFORMDEFINITION,
            OUTPUTDEFINITION, HASAPPUSERIDPARAM
            from dbo.SMARTQUERYCATALOG         
            where SMARTQUERYCATALOG.ID = @ID

        return 0;