Luis,

Your code is also working perfectly! No problems with a smaller streak.

Thank you again.

Kind regards,

Robert

Hello Luis,

I am not feeling offended, just appreciating your remarks. What you are saying is that I should use varchar(40) instead of nvarchar(max). Normally I do that but in this...

Hello Lynn,

I tried your solution and it is working perfectly! I don´t quite understand it yet, but I´ll give it a try. The only difference between part 1 and part...

The expected results (in this case) would look like:

Streak Sport Event Gender Country From To

7 ...

I tried almost everything (including a cte) but nothing worked. The problem is that a range that is discontinued (eg Korea female individual) I cannot get the code right to...

Luis (and others) stupid mistake: of course select.. into instead of select insert into. Typical newbie..

As a sort of wrap up: I changed your code in the following way (minor...

I use the following code (last part):

SET @sql = 'SELECT ev.Event_Name' + CHAR(10) + @sql +

'INSERT INTO dbo.Results FROM #Events ev ' + CHAR(10) +

'WHERE ev.event_year...

I tried the following (after making a table calles Results):

SELECT @sql = String FROM SQL_String

SET @sql = 'SELECT ev.Event_Name INTO dbo.Results' + CHAR(10) +

Luis,

A Select Into will do, but where in your code does it appear. In between in place of something else or at the end but with what variables?

It sounds stupid,...