To h.tobish:

I very much appreciate your informative comment about the CTE "recursion" not really being an actual recursion.

Thanks for the short and sweet example on how to do the recursion with CTE's.

That is useful. Now this will guide me in understanding how to do this.

BUT it is...

I think you missed my point.

What I am dismissing is applying what amounts to a sledgehammer when the issue was to drive a 1 inch nail in a 2 X...

Recurse ?

I am weary of recursion. I view it as meant to be used for special cases. I have seen a demo concept of calculating factorials with recursion being...

This article provides a good INTRODUCTION to a set-based method of eliminating "row-by-agonizing-row" (RBAR) cursor code but it is not the complete story. There is more information to consider BEFORE...

A debate on this topic ?

I'm in.

COUNT() sounded so simple, I never bothered to look up on TechNet to see if there was any "fine print".

It is another lesson learned,...

Would it help it a permanent table was used ? You could dump the id's along with a common GUID and when you are done delete all rows with that...

There are many standards for EDI and within each standard a distinct definition for each type of file. Which type of file are you trying to import ? An Order,...

Unless, I missed something in understanding the EXCEP statement,

Why not simply use something like

SELECT TOP 20 * FROM PostCode

EXCEPT

SELECT TOP 10 * FROM PostCode

Thank you for your suggestion.

I'll work on it when I get back from vacation next week.

Update - tried it - solved my problem.

Regards

This looks promising. Looking forward for more.

What are your plans ?

Visual Studio 2008 or the SSRS report builder ?

Will you use SQL Server datasets or use FetchXML ? FetchXML did...

Got it right, for the wrong reason.

I thought that only select A was part of the stored proc. and that execution of the stored proc (select A) would be followed...

Thank you both.

Regards

Not what I wanted to hear.

But thank you for your assistance.

Regards

I have encountered a similar situation w/r to placing sums only in footers.

What I did instead was to generate in T-SQL a table variable which is first populated by the...