1 Reply Latest reply on Mar 28, 2016 5:08 PM by Russell Christopher

    Stored Procedure doesnt return a result set,or the result set columns do not have names

    vinutha vasanthu

      Stored Procedure doesn't return a result set,or the result set columns do not have names.

      Please find the screen shot attached.

        • 1. Re: Stored Procedure doesnt return a result set,or the result set columns do not have names
          Russell Christopher

          Hi Vinutha -

           

          You haven't really posted enough information for people to try and help. At a minimum, we'd probably need to see the CREATE PROCEDURE statement for the sproc you're trying to execute.

           

          Based on the error message, I'd bet one (or both) of the following could be an issue for you:

           

          • The sproc is returning multiple results. Tableau doesn't support this. Use SET NOCOUNT ON  in the sproc and make sure the first resultset that comes back actually has useful rows
          • You have fields being returned in the resultset that aren't explicitly named. Make sure every column has a name (ala SELECT [field] * 10 AS MyFieldName FROM Table vs SELECT [field] * 10 FROM Table)