Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NIRVANA
Starting Member
4 Posts |
 Posted - 2009-02-25 : 21:30:33
|
| I have a query in a stored proc lets say the followingselect * from Business where unit = ???Now in my stored_proc i have a query like the one above in a cursor and all is working fine, for each result i insert into a temp table(as i am doing some extra manipulation for each type of record) and then do a slect on the table to get the data. Tis all works fine but i would like the results to be displayed like a normal query you may run in a stored proc(minus cursor) the reason for this isThis proc will be on a reporting server (2005) and may be a case when users run the reports at the same time hence the possible clash with temp tables.Now i have tried to assign the data to variables and then print the variables which prints it, but if you try and retireve the recordset from a custom VB app or Reprting Server the recordset is blank, but if u look at the results in Query Analyser they are there but not in the same format as a normal query.I would like the results to be like normal query results, this way i can dispense with tmp tables and the reports can be run at the same time.Is this possible. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-02-26 : 06:44:58
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=120580 |
 |
|
|
|
|
|
Cursor Results in Stored Proc