Posted by Otter at 10:27am Apr 22 '10t-sql supports procedural scripting and I could write a procedure using variables that does this.
That's mostly what I needed was just some help with the logic of the idea. I've been working inside this "box" of thinking that made me concentrate on live queries, unions, includes, excepts, etc.... Put me into little circles.
Another thought I had was
UNION ALL
then
Order by YEAR
then
Select Distinct
but I'm not sure that would be entirely accurate results.
Do you know how select distinct works, does it run right off the top of the records, whichever distinct record comes first gets placed?
Regardless of that though - I think I like your idea better.
Thanks!
That's mostly what I needed was just some help with the logic of the idea. I've been working inside this "box" of thinking that made me concentrate on live queries, unions, includes, excepts, etc.... Put me into little circles.
Another thought I had was
UNION ALL
then
Order by YEAR
then
Select Distinct
but I'm not sure that would be entirely accurate results.
Do you know how select distinct works, does it run right off the top of the records, whichever distinct record comes first gets placed?
Regardless of that though - I think I like your idea better.
Thanks!
great idea! - Otter