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?

It's not what I asked. Do you want the data for which there are 10 consecutive minutes and ignore everything else where there's less than 10?

Nice trick... I assume that this is well documented because it's not the first place I'd be searching if a bug was found in the application

I'd go with the best practice that says you shouldn't start an external process in a trigger (mail/dts ...).

You're idea is not bad, but do the users need to run...