calling SP containing Temp table in IReport

Posted on September 2, 2006 at 1:30pm
By: Jhonny Bravo - ac48
calling SP containing Temp table in IReport
2005-11-09 06:18
hi folks
i m trynig to call a stored procedure using IReport and there is no
problem with that and the procedure gets called ....
but if that procedure has a temporary table then I cannot get the records in my Report....

So if any one of you have tried the same plz let me know

thanx in advance




By: pubDispName - mellino
RE: calling SP containing Temp table in IReport
2005-11-09 06:45
How do you call store procedure ?
iReport Designer
2005 IR Help's picture
2005 IR Help
2873
Joined: Aug 9 2006 - 3:40am
Last seen: 17 years 1 month ago

1 Answer:

Posted on February 12, 2007 at 2:14pm
If you are usng SQL Server local temporary tables, and they are creared within the stored procedure, their lifetime is the lifetime of the stored procedure.
sualeh's picture
sualeh
3
Joined: Sep 24 2006 - 11:01pm
Last seen: 17 years 19 hours ago
Feedback