Please refer to the link in my signature for an example of how to post table definition and sample data. There will probably be additional questions on this one,...

So if you remove the Order By, it functions the same on...

smunson (11/3/2008)

---

Unfortunately, your example from several pages back conflicts with a statement by the OP that no range contains a duplicate, and your example starts out with one, unless he...

Thanks for the feedback moin6, glad we could help. Feel free to post your other questions as well.

Did you see my breakdown of the logic involved? I think it's pretty unambiguous, and covers all scenarios. The logic behind it is actually not as complicated as...

Dan, any updates for us on the performance and integrity of any of the proposed solutions? I believe there are at least 3 right now (Mine, anzio's and bhovious'......

I either overlooked that or it wasn't there when I initially read the reply......

The commented out criteria in your original cursor declaration was

-- ScheduleId IS NULL AND StartDtTm > '10/20/2008'

This would give you a set where all ScheduleID's were null. Then, at...

The issue isn't the cursor itself, it's the fact that you've got NULL =...

I don't use cursors much, but it seems like you're missing a FETCH NEXT within your loop. You fetch the first set initially, and then begin your loop, but...

I think I'm understanding you correctly. I had to compromise a bit with the LIKE, as you only wanted 1 row when you selected everything (which means you can't...

Yerp. I actually gave an example earlier where I used a table variable, but it doesn't support the WITH INDEX clause, and this actually served as a reminder that...

Think you're looking for something like this. One of the biggest issues is you forgot something vital... something that rhymes with "Flustered Windex".

PRIMARY KEY CLUSTERED(RowID, SegmentID, STEP2)

[font="Courier New"]        DECLARE...

You don't need a loop, or a cursor. All you need to do is:

1. Create a clustered index on your row# column. (It is most likely already...

This is a duplicate thread. Please direct future replies to:

http://www.sqlservercentral.com/Forums/Topic595159-338-1.aspx