Thanks.

Is it possible to include in between new data?

Newrecord

chicago

20pax

Newrecord

Spain

10pax

Newrecord

austria

90pax

I'm getting this error.

Any idea?

The type of column "" conflicts with the type of other columns specified in the UNPIVOT list.

I tried that way but not in order.

Same store proc but different parameter. Results send to different recipients.

exec store proc A 'henry','getdate()'

send to henry@gmail.com

exec store proc B 'george','getdate()'

send to george@gmail.com

Doing this 1000 times? Any suggestion...

I have like 1000 recipients. I need to do that 1000 times?

Any idea how can I solve this?

There are no other way?

As the list are growing.. Feel like not efficient doing it one by one.

I tried still the same. It only will pull from 00:00 till 19:59.

As my end I schedule it at 4am (gmt+8).

Thanks is working fine.

I tried but it appear more results row.

Yes I would like to pass in the parameter.

Where to store the VBA part? shown in step 10-11.

Manage to connect and result appeared.

How to pass in the parameter?

Don't understand on step 10.

Any step by step guidance?

Hi

Shawn Melton

The link not working..

would like to see the ID in 1 row instead of duplication.

Thanks. Is working fine now.

Im trying to pull it every hour.

The method you provide need to be done manually?