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 |
|
abarsami
Yak Posting Veteran
68 Posts |
 Posted - 2001-01-15 : 22:03:24
|
| Help my recordcount = -1Why ?In my stored proc:Set @TCursor = Cursor Static For[my select statment]Open @TCursorFetch Next From @TCursor Into[variables]while @@fetch_status = 0 BEGIN Insert Into #temp ([I insert values into the temp table]Fetch Next From @TCursor Into[variables]ENDClose @TCursorDeAllocate @TCursorMy asp code: rs.CursorType = adOpenStaticAny Ideas? |
|
|
|
|
|
Help with Cursor.