Thanks a lot, I appreciate your help with this.

Hey Matt,

Where's that Tally table you are cross joining on?

So, the TOP keyword in the SELECT is not working for you?

Do they have to be grouped somehow or ordered in the result set?

Look at the order of the execution of the statement.

1. Evaluate FROM clause

2. Evaluate WHERE clause

3. Evaluate GROUP BY clause

4. Evaluate HAVING clause

5. Evaluate SELECT clause

Your SELECT clause with the...

Sorry for that. I'll try to explain what's happening.

Let's say I have 3 records in my Price table

RowID BeginDate EndDate Price ($)

----------------------------------------------------

1 ...