SQL Server Cursors vs typical SQL statements

[tdh2]

Hi,

I am a newbie to SQL Server cursor. Would you please give me a simple and practical example of using SQL Server cursor and typical SQL statements (correlated sub-query or derived tables) in term of coding as well as sample of query results based on the coding?

Thank much,
tdh2

 

[jbenson001]

Check here for examples and on line. Also, don't user cursors! You can write most sql in a set based way or use a loop if you need too.

Jim

 

[BrianBurgit]

Can you point me to an example of a set based way, where a loop is used, or just provide some quick syntax?

 

[gmmastros]

Brian,

It may be better to post a question regarding your cursor/loop based query. Converting a cursor based query to a set based query does not usually follow any sort of step by step based approach. Post your query, and we'll see if we can help.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom