Can you post the query, the execution plan and the table definition with its indexes... maybe we can speed it up still (don't know any time out settings in reporting...

Select will be slower than exists.

Exists returns true or false. A select will return a recordset, which is longer to create (especially if there are many rows in the...

Ya just relooked at that part, they are using the sp_depends stored proc to get that info... and we all know how reliable that info is.

Still seems like a great...

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...