Amen!!.

No pay is worth looking like a penguin all year long .

You can generate a text version of the plan or you have to take the print screen image and put it up on a webserver so that we can see...

24 of 4????

Good point however .

That's an easy fix :

Where Date >= '2006/09/04' and Date < '2006/09/05'

Can you run that query and send us the execution plan??? maybe we'll figure out what's taking so...

Good point... I forgot that you pretty much had unlimited variables with that function .

I don't know what wrong... but have you tried this instead??

while @@FETCH_STATUS <> -1

All I can spot is this :

RTRIM(Convert(Char(10), p.SeizeDate , 112 )) = '20060830'

That forces the server to do a table/index scan instead of doing a seek.  If the table...

I see now.  Were you able to make my demo code work for you?  Are do you have any more questions?

HTH .

Need anything else?

Thanx for the info.  I was under the impression that the conversion tool was not doing a really good job of converting to .net.  I was wondering about those pitfalls...

I understand that porting an application from mysql to sqlserver can take a huge amount of ressources.  But can someone explain me really how hard it is to port from...

Exactly my point...  Why do you think you need to do this?  It is considered a worst practice (almost) to have to do something like this (there are rare exceptions). ...

Declare

@demo table (RewardID INT not null IDENTITY

I'll happily show you how to do this, but I'd like to hear what you have to do exactly... maybe there's a better way to do this stuff than creating...

Do you mind posting the real code?  I don't see anything wrong with this... and more so I really don't see the need to use a cursor in this case.

You...