... and your homework is done... 😉

If it's not...

What have you tried so far as a source?

I'd expect google will return numerous related articles being a lot more specific than a forum post can be...

Looks like homework... You might want to look into aggregation task or GROUP BY in TSQL.

Unlikely. The tree is already occupied and I can't spot...

Brandie Tarvin (12/10/2010)

---

LutzM (12/10/2010)

---

A similar option would be adding another table CoverageVersionsHistory with the current CoverageVersions structure and move all outdated versions into this history table on a scheduled base....

Seems like we're both confused now... :ermm:

Attached please find the snapshots of the execution plans I get when running the queries on your sample data (I didn't include files as...

A similar option would be adding another table CoverageVersionsHistory with the current CoverageVersions structure and move all outdated versions into this history table on a scheduled base. So, instead of...

You get a table scan because your subquery has no limiting WHERE condition. In order to find max(Effective) per CoverageKey you'd need to scan the entire table (or clustered index).

One...

Please post the actual execution plan so we can see if there's a possible index issue.

Without knowing your current code (where did you place the TRY CATCH block?) it's unlikely we can help to solve the issue. So, please post the relevant code snippet.

I don't understand why you can't use PIVOT on your system...

Anyway, here are both solutions, PIVOT and CrossTab.

SELECT

Jaar ,

MAX(CASE WHEN Koersnaam ='Giro d''Italia' THEN Coureur ELSE NULL END) AS...

I'd also recommend to just skip SQL2000 and move at least to 2005 (even better 2008).

Reason: There are major changes between 2000 and 2005, not only internally, but also in...

Ok, after clarification of the system you're using we'd still need some ready to use sample data....

I don't think you'd need to ask the question again in the SS2K8 forum....

Regarding the lookup: I found

Jamie's blog very helpful. It might add some more benefit to your task performance, too.

Please post table def and sample data in a ready to use format as described in the first link in my signature. Also, please include the expected result based on...