>I ended up using COUNT(*) as RowTotal and using:
>
>
>RowNumber<RowTotal
>
>
>...in the second portion. Is there is a better way, you may let me know.
You can use some arbitrary number, say, where RowNumber between 2 and 1000 and otherwise the condition will remain exactly the same as my original select statement.
If it's not broken, fix it until it is.
My Blog