To re-create a stored procedure you will be better off using QA. To call it use the MS Access Passthrough query type!

I don't think so! ... Eagerly waiting to see what is the advantage ?

I may not be an Access Monster but i can tell you that you can call sp in Sql Server through a MS...

Thanks for the feedback.

 I know many people that use red-gate and this thread may be helpful to keep around

>>Certainly one 1-million row update is better than 1 million 1-row updates, but is it really THAT much better than 20 50,000-row updates or 100 10,000-row updates?  I think there...

Sorry I had to do some stuff:

I need probably some sample data to give an adecuate solution but should be something like:

Update t Set  dtLastInspectionDate = A.MaxDate,

           dtNextInspectionDate =...

I think that if you need that MANY tables you'll need a different approach or your data will become unmanageable.

I will try any of the following 2 options.

1. Create...

I am sorry to be the BAD news guy here but that Trigger can't handle multiple records!

you should change the logic to a set...

thats why I don't like loops or cursors ... I use SET-BASED answers

Scott,

What is your problem with synchronous updates. SET-BASED updates beat the hell out of single updates no matter what method you use!

Lets make a quick comparisson:

The temp table is just...

Paul,

If what you need is

>>

What I wanted was a quick and easy way of showing the results of a crosstab query on a sudden demand basis.

<<

then with Querydef.Open you...

I am almost certain that it is possible to perform that formating client side without coding on most report writers!!!

Let me get something clear,

#Temp Tables are unique per session!  if you have several jobs #T1 for job1 is not the same  than #T1  for Job2 even though they have the same name.

The...

OOps! Glad you solved it

Different than me but hey good for both of us then!

I Was able to doit with the OLEDB Provider!

NO NEED for USE

You can use : the following connection string!

openrowset('SQLOLEDB',

'SERVER=XX;UID=XX;PWD=XX;DATABASE=XX',

'YOUR QUERY AS IS!!')