Good for you, Robert, and thanks for letting us know that you have a solution now. Good luck to you in the coming year.

One comment on your...

CTE is short for "Common table expression", which is an alternative to using a subquery. The CTE is not a temporary table; it produces a result set...

(1) You must ensure that the second query (following the UNION ALL) produces the same number of columns as contained in the temp table, even if that means forcing...

Now I want a last row called Aantal which gives in 1948: 2, 1949: 3 etc., which stands for the number of competitions that year (so counting the not NULL...

wilburb (12/28/2010)

---

While I appreciate your frustration and point of view, I must say that as a resource in a rapidly changing environment I use many forums to augment my knowledge....

Jeff has a GREAT speaking voice.

I understand. You are showing wisdom by rethinking the process while you can. Best of luck to you in the new year.

No problem. Thanks for letting us know it's working now. Best of luck to you.

I'm afraid I'm not going to be much help. I built and populated the table using your scripts and then ran the original calls to the...

Congrats Paul and Gail and Merry Christmas everyone !

And who deserves the credit?

And who deserves the blame?

Please post the schema of the LOGSHEET.dbo.boundary table, and a script to populate a few sample rows and I can have a look at this tomorrow.

tfifield (12/21/2010)

---

Much of what you want to do depends on the distribution of the data. If only a small percentage of the rows in the table have one or...

!!

You're welcome, Stephanie, and good luck.