Typed Dataset using storedprocedure that contains temporary tables

[Guest]

Hi all,

I have a stored procedure that returns me data joining 2 temporary tables in it.
I am trying to create a typed dataset using this stored procedure which doesn't allow me to do. If anybody has this problem or know about this, pls need help.

Thanks in advance
Sapna

User submitted from AEWNET (http://www.aewnet.com/)

 

[David Browne]

Hi all,

I have a stored procedure that returns me data joining 2 temporary tables
in it.
I am trying to create a typed dataset using this stored procedure which
doesn't allow me to do. If anybody has this problem or know about this,
pls need help.

When you use temporary tables in a stored procedure SqlServer cannot figure
out the what the row looks like that will be returned. Either build the
typed dataset by hand, or put a dummy table in your schema with the same
rowtype as your procedure returnes. Use the dummy table to build the Typed
DataSet in Visual Studio, but fill the table with a call to the stored
procedure.

David