When given a report with an incomplete specification and/or garbage data, and there is not enough time to verify everything, the trick is to document every gosh-darned assumption that you...

Thank you very much, Peter! No matter how many times someone discusses table variables vs. temp tables, it seems as though there are some more wrinkles to explore.

Two things...

Please don't flame me for suggesting a poorly performing technique. The code below works great with a minimum of programming... but only when the two initial assumptions are correct!

If...

Thank you, thank you, thank you Charles. If only Microsoft's documentation could be as clearly written as your article.

Curt