I have created a SQL Stored procedure, that when run in SQL environment provides correct data. However, when I use this stored procedure as a data souce in tableau desktop , it retrieves incorrect data.
The stored procedure is a 4000 lines of code made with the use of SQL temporary tables.
Any help is appreiated.
I would be more tha happy to help with the unexpected behavior.To better assist I have the following questions.
+ How is the data incorrect? Missing data, unexpected nulls, not as many rows as expected?
+ Is there an error being produced?
+ What Version of Tableau is being used?
+ Versionof SQL server?