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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Retrieving Data

Author  Topic 

phipjef
Starting Member

1 Post

Posted - 2005-12-13 : 17:49:34
Hello All...

I need to retrieve some data (multiple fields) in a stored procedure and then assign the data returned to variables to do a comparison. Is using a cursor and fetch the best way to retrieve the data? Is there a more efficient or better way? Thanks for the help.

jonasalbert20
Constraint Violating Yak Guru

300 Posts

Posted - 2005-12-13 : 19:59:56
Kindly post your sample data and query?

Want Philippines to become 1st World COuntry? Go for World War 3...
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2005-12-13 : 21:52:08
Also post your table structure. Tryt to avoid using cursor.

-----------------
[KH]

Learn something new everyday
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-12-14 : 00:16:11
As suggested here
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -