Let me restate what you are doing :

You have a table on sql server with 80M + records that you need to transfer to access.

You can simply dts the...

You can't, you make 2 different statements, or you move the case to the where condition :

Select * from dbo.AllDates where 1 = case when X = 1 and...

Apex is probabely cheaper, but I'm funnier and can do more than just documenting .

Still doesn't work...

10JohnA

10John1A

Mack

Rock

40SilkB

MannC

You have one too many 10 and A, you also miss 20 and 30 in the ids.

You're right... come to think of it I don't even use this function. I Always refer to my holidays table (don't have a full calendar because I have no...

I just had a look at it and it looks incredible. I assume that there are flaws but I can't find 'em atm :-).

Anyone took up my challenge yet?

Exactly my question... what was wrong with the proc??

Thanx for the info.

So what's the final (shortest) datatype for this problem?

Anyones already done this in a real application and can relate the pros and cons of changing from the...

No offense to your developpers, but I think it's the most impotant thing in the proc (besides the fact that it works).

I challenge anyone to tell me what this code...

Why are you trying to do something like this?

No, that would take a computed column or a trigger .

That's only 70 mb of data to transfer... it shouldn't be lightning fast but it shouldn't take 30 minutes.

Is the Access db on the same machine as the sql server...

I don't have nor know where to get that list, but I think that if you convert the cross join from a delete to a select, that you will get...

This query returns :

10JohnA

10John1A

20Mack

30Rock

40SilkB

40MannC

if I understand his requirements he wants this (without the __) :

10JohnA

__ John1__

20Mack

30Rock

__SilkB

40MannC

Totally agree with that Frank. Keep the server serving and the application applicating the presentation .