USP_SMARTQUERY_GETMETADATA_FORQUERYEXECUTION

        create procedure dbo.USP_SMARTQUERY_GETMETADATA_FORQUERYEXECUTION (
            @ID uniqueidentifier)

        as

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

        return 0;