Hello Luis,

here is the DDL Script.

x in the comment part shows that I uses a different naming convention than you.

The cases are named by a to h. (they are not...

Hello Luis,I think the naming convention of the FK is a problem.

First:

ALTER TABLE [dbo].t1 WITH CHECK ADD CONSTRAINT [t1t2] FOREIGN KEY(c1, c2)

REFERENCES [dbo].t2 (c1, c2)

GO

ALTER TABLE [dbo].t1 CHECK...

Hi Luis,

in my first post I use the old data.

in all other posts I use the new script.

So my first problem is solved, because I use of outdated data.

But the...

Now I tested the third command

Here are the results:

--groups = problematic solution

--groups2= set-based loop

--groups3= set-based solution

--set-based loop vs....

also the new testdata gives 60000 records for:

onclick:if_IFCode('','');

select * from groups2 g2 inner join groups g1 on g1.clientid =g2.clientId where g1.OriginalMemberId<>g2.OriginalMemberId

Thanks for your great article.:-)

I have a problem with three “While”-loops and was searching for a better solution.

Instead of using the “The problematic solution” now I use your “Set-based Loop”....

with german settings,I got

datefield intField

2010-07-01...