Oh yeah... absolutely.  That's part of why I was asking... Not having a PK on the table really seems dumb.  And, I absolutely agree with Marty on this one... the...

That's what I'm talking about   Once we know what you need, Jan, lots of folks have great solutions to avoid the cursor. ...

You've missed the point, entirely, and I doubt you have any real understanding of the solution.  Good luck, "sir"... you will need it.

Considering that only two rows of a table are being accessed for the original question being asked, I'd have to say the delta-t would be measured in nano-seconds.  The big...

LOL!  This is where I'm supposed to say something like "Do it in the app"...

So, explain the code Gail wrote for you... I wanna make sure you actually learned something other than how to get other people to do your work for you...

Figured the original poster wouldn't have gotten a thing out of it... you know... the "flying pig" thing...

Ooooowwww.... why on Earth do you want to do this?  Even if it's just a report, if someone needs to ananlyze the data using any form of aggragation, they're pretty...

>>i geting problem.

Any chance of you describing what that problem is?  Error message? ????  You might get people to help a bit quicker that way...

Sam,

I don't work with multi-lingual databases so I've no example for you.  However, COLLATE is the answer you are looking for... take a look in Books Online for COLLATE.

This is a very "old" problem and there must be a thousand or so posts on how to do this on this forum alone (search does work)... but, here it...

Not sure, Gail, but I think you just did someone's "urgent" homework for them...

I'm right there with Serqiy... I use system functions whenever I can...

I'll probably get my head handed to me for using undocumented features but I believe this works both...

That also takes care of the problem when unpredictable lengths occur without a hint of a loop.  Nicely done!