Some people really dont want to be helped do they :crazy:

http://www.sqlservercentral.com/Forums/Topic1116629-9-3.aspx#bm1117914

Also, please confirm which version of SqlServer you are using.

This is a SqlServer 7 / 2000 forum, are you using a later release ?

Maybe you could show us the code that you have achieved so far yourself ? That would help us in the best way to advise you.

Different queries , different times ?....

Could be something outside of SqlServer, are you on a virtualised machine , Anti viral (seen that more than once), is sqlserver memory...

There's to much going on to tell you where that problem lies.

You are going to have to isolate it further.

Im afraid that your question exposes the fact that you dont understand what an RDBMS is at a rather fundemental level.

You should not be thinking about going row-by-row.

Try this book...

Echo those thoughts , i could only justify going if...

You could try a computed column with an index then, there are a few hoops you have to jump through though

http://msdn.microsoft.com/en-us/library/ms191250(v=SQL.90).aspx

You could try a logon trigger

http://msdn.microsoft.com/en-us/library/bb326598(v=SQL.90).aspx

Thanks to all those who proof read and commented on my 'cursors' article , finally submitted it to Steve today.

Dont thank me , thank Gail (GilaMonster).

There are a few expections , but as a rule of thumb , never use functions on the columnar side of a comparision. SQLServer has to scan each row,...

Hi , see this page for a breakdown of your options

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

A goto will jump to a point in code , that code will still be executed as the flow of the program naturally passes it ,that is what has happened...

Ok , going to forget about the cursor one.

Custom components it is , see you in Seattle (hopefully :))