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 2008 Forums
 Transact-SQL (2008)
 Avoid Cursor

Author  Topic 

Gordon.Davis
Starting Member

4 Posts

Posted - 2011-05-31 : 16:48:20
HI All,
I have a Cursor which will run based on the Column Value i.e Y/N.If it is Y i have to run some merge Statements if it is N some other statements.Now i have lot of rows to handle i'm facing performance issues.Could You please help me is their any other way of approach to avoid cursor.

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2011-05-31 : 16:55:12
You'll have to give a little more info for anyone to be able to help you.

For example,

Table Declaration
Type of Statements run in each case

Sample Data would be awesome...





Corey

I Has Returned!!
Go to Top of Page
   

- Advertisement -