You'd be the first to understand all this by himself.

Up to the challenge ?

Is it possible that the user doesn't have permission to run FileProperty (can't find any info about the minimum permission required)?

As I explained you'd need to replace all the (') with (''). Or you could create a stored proc and avoid the problem altogether. It would also shield...

You only have 2 minutes to cut down... shouldn't be too hard .

Thanx for confirming .

One last question (I promise ).

Is there a possibility that you'd have more than 1 record for the same date (to the minute,...

Create a temp table with the same structure as the results then do this :

Insert into #temp (col1, col2, id) exec(@Statement)

As always, I guess it depends .

Sounds like dynamic sql to me.

Can you post the code you are using the create the query and execut it.

Pre-hint... double quote your quotes (' becomes '').

The code seems alright, the only small idea I have is to change the double quote with a pair of single quotes.

The real question is what are you getting?

What should...

Here's the code I use in vb for such a situation

Private Function exec_AutoExecPinTableNumbers(Optional ByRef ReturnValue As Integer) As Integer

On Error GoTo Gestion

Dim MyCmd As ADODB.Command

Set MyCmd = New ADODB.Command

MyCmd.CommandText =...

Why would they call you if you don't work there anymore??

They'd have to keep me on payroll to keep me on call .

I've already seen a thread with 10 answers in 15 minutes... This was a slow one by our standards .

everyone. The only difference is that the managers can update the table directly while public must use the procs.

if there are only 10, do you want only the first, or the first and tenth?