The exact error is - Could not generate a list of fields for the query. Invalid object name #temp. cheers
Knarf, still the same thing happened after I change the declaration. Invalid object name '#temp'. Any help? cheers
Below is the sample of the store procedure that I created. ************************************************************* CREATE PROCEDURE...
ok .. now I have created a stored procedure that basically follow the example above. Am I going to create the temptable manually before running the...
Hi Knarf, Do you mind telling me in detail how to do the Rollup process that you mentioned above? Because I am beginner to this reporting service. I...
Hi all ... I have a problem of putting all the results together from few datasets. Since I have a sql query statement which output more than 1...
Separate names with a comma.