I did not realize the order didn't matter in the 'top' select statement.

I guess I just don't know data mining that well (obviously I'm a newb in the newb forum),...

But I cannot do "select 1,2,3,top(100)4"...

The 'top' portion has to be #1 in the select statement, no?

At least when I try to do "select 1,2,3,top(100)4" it gives me an 'incorrect...

Well, I've never started a query with anything other than 'select'! 🙂

So I don't quite get:

;With OrderSet (DrugID, OrderSetID, OrderID)

As (

but, I...

Oops, I got it! Don't use EXISTS I guess. If I end the query with

"where x.DrugID in (etc.)" it works!

Yay, good stuff, nice and pretty now. I...

Thanks for the 'union all' piece. But I don't know how to use it exactly. I can get all the info in 3 columns, so that's nice! ...

It does help me, thank you both.

I can look at the complete code and break it down backwards and understand fairly well what it is doing. It's like a...

TY guys for the help. Celko, your code worked for what I was looking for. I do not understand the "DENSE_RANK() OVER" portion or how you referenced a...

CELKO (9/14/2010)

---

Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. in your schema are. Please learn to follow...

Well, you guys are much better than me at this stuff. I need to query the table given to me, not create one, and I kinda get lost in...

but i cannot do "select 'a' and then 'union all' for millions of rows!

is there no other way?