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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-15 : 08:26:19
|
| sandra writes "Using stored procedures.Fetching about 60 columns, don't want to have to pass each column individually to called procedure. Will be calling the procedure from 2 different locations in the code. So need to make this as straight forward and simple as possible. All help greatly appreciated from former Oracle programmer...Thanks, Sandy...." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-15 : 08:48:10
|
| Why use cursors at all? They're not the preferred way of doing things in SQL Server, and they don't work like they do in Oracle.If you post your table structures, some sample data, and the desired output, we can work on getting you a solution, cursor or not. If you can also post your current code that would help too. |
 |
|
|
|
|
|
how to pass fetched cursor values to a procedure from a calling procedure?