My assumption was that a result set will be created with row numbers assigned by column "myno". And then I am ordering the result set by another column ([Type 1]...

Hello, again. I see now that you asked a similar question about a month ago.

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

Chris offered a possible solution that, like the one I just suggested here,...

This could probably be solved using aggregate functions with Group by. Your sample data is inconsistent in that not all rows specify the same number of columns. Also,...

Which five rows would you want to be returned? Mocked-up desired results should clarify what you're trying to get here.

You've given them an order-by for the row_number() function that's based...

I've not seen anything like that. Usually, as in this case, the original...

Thank you for providing the test data.... I may be missing something about what you want to do, but it seems that just moving the "order by" to the end...

Julio,

Please offer us the data you see in your table and the time value you expect to see for that number. I can understand if, for instance you said...

Gaby Abed (5/28/2009)

---

Bob Hovious (5/28/2009)

---

Gaaaahhhh.... I get really focused on my real life and work for a couple of days and I miss all the excitement. :w00t: ...

I apologize for jumping in by posting a question on one of the echo threads that Gail shared. Didn't realize that consensus what that to leave it to Steve and...

Pradyothana,

Why do you post copied text from other people's posts? Do you mean to comment on them and just hit...

So, everyone's waiting for someone else to post numbers 4996,7,8,9....This somehow reminds me of a sprint bicycle race where the two athletes will balance on their bikes at a complete...

Hello, Expert Gurus!!!!

I need to know what "SQL" means.

Is an index the opposite of an outdex?

IF U DON"T KNOW, PLEAS DOn't AnSer me.

Urgent, urgent, urgent..... My...

Paul White (5/27/2009)

---

[font="Courier New"]Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).

Case expressions may only be nested to level 10.

Syntax error at line 5.[/font]

[font="Courier New"]Post count was...

Ah, the secret formula for building up points without actually demonstrating SQL acumen or adding value...