Viewing 4 posts - 1 through 4 (of 4 total)
Just gave it a try and works like a charm.
Thanks again!
June 16, 2009 at 7:35 am
Florian Reischl (6/12/2009)
You can use a CTE to get a row-number over your order-id:Flo
Hmm... never knew this feature existed... time to start swatting up on the Common Table Expressions.
Thank you...
June 12, 2009 at 2:41 pm
Tom Brown (6/12/2009)
you have FROM FROM on line 2.sometimes you just need someone else to look at the code 😉
LOL... that or a second look after an...
June 12, 2009 at 2:35 pm
Duh... that'll teach me about trying to code SQL on a Friday afternoon. I had a FROM statement in there twice...
Nevermind folks... nothing to see! 😀
June 12, 2009 at 2:28 pm
Viewing 4 posts - 1 through 4 (of 4 total)