TableAdapter Configuration problem while attaching storedProcedure with temp table in Typed Dataset

TableAdapter Configuration problem while attaching storedProcedure with temp table  in Typed Dataset

We create typed dataset (.xsd) for reporting (crystal report), 

 If  i am binding stored procedure with simple select query then it will configure TableAdapter properly

and returns the data columns in the select query of stored procedure.

But the problem is that when we are returning the data from temporary table (#temp) from our stored procedure, then it will throw error message ( The wizard TableAdapter configuring error: 

Generating Select Statement problem

while selecting #temp table) as here #temp table is temporary table created to return result & after that table is destroyed.

So to over come this error (problem) just add following lines into your stored procedure before creating & selecting data from temporary table.

IF 1=0 BEGIN

SET FMTONLY OFF
END

these lines will remove the specified error.

Hope this will help you .....

Thank you..