Hmmm , get rid of the @ tables and use # tables, i think your dataload is to large for them.

Also make sure your statistics are up to date...

Please post the query plans and full SQL statement. Im guessing that its not columns per-se that cause the issue but possibly a bookmark lookup to retrieve them

No Problems , but the the way to REALLY confirm what parameters are being passed is with SQLProfiler, it would of highlighted this.

If you have do ask then you dont need to know 🙂

Basically they allow you to override the optimizers functionality to specify an execution path.

You only need to use...

Well, there has to be a difference some where.

Its either environmental (SET options) these can be seen in from sys.dm_exec_sessions or the parameters that are being passed. Dont...

And what parameters is it being called with,

Confirm with sql trace the exact parameters (including NULLS) that the webserver is passing.

Please post the full code, but at a guess it sounds like that the connections are using different ANSI_NULLS settings which could account for the difference.

Depends it you need to store the value or not,

presumably seq_no is partitioned by seqno so an identity column will not be suitable ? or will it ?

Try...

Does due date contain a time ? You cant separate out the time portion, try between 00:00 and 23:59.

Try this link for more info http://www.karaszi.com/SQLServer/info_datetime.asp

Thanks Paul , this gave me the expected result. But i need to test under different situations.

Which one will be better ? a cross apply or with cte ? i...

I believe so , but i would encourage , and expect, you to understand the code and to ensure that the given solution works under...

Did you try my suggestion ?

It gives you that...

Assuming 2005 +

with ctedata(id,data,rownum)

as

(

Select id,data,row_number() over (partition by id order by data)

from tblData

)

select cteData.id,cteData.data

from cteData,

...

There are no sarg's on you update statement,

You probably meant to say

Update Table

Where current of CursorName

Take a look in books online for more details.

I would also argue that you dont...

NoLock is very dangerous if you dont understand the side effects

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx