great idea!

4thKingdom | Computers Board | Join Free

Posted by Otter at 10:27am Apr 22 '10
You must sign in to send Otter a message

t-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!

There are 11 private posts in this thread. You need sign in to read them.

Below are the public posts in this thread:

Note that there are no ads here. Just intelligent and friendly conversation. We keep the spam out, the trolls out, the advertisers out... 4K is just a low-key, old-fashioned site with members from around the world.
This community began in 1998, and we continue to accept new members today.

If you're looking for a richer experience than Facebook or Twitter, this is it.

Debate & News Extreme Help & Advice Lifestyle Media & Arts Special Interest