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)