stricknyn (12/9/2008)

---

Hi, yes I am only using the listed tables. I'm trying to figure out how to do update with a Execute SQL Task based on how I have...

You're welcome Ian, and thanks for taking the trouble...

How long does it take to run once?

How many times is it running in the procedure which brought it to your attention as being a potential bottleneck?

Ian, could you please set up some sample data for each of the three tables as indicated in the link below? You will also need to provide a table of...

Joe, the syntax of your sp and the statement calling it look exactly correct to me. Provided that the output params are DECLAREd before the sp is called, they should...

Have you really got two tables in this update, dbo.PROVIDER_PARTICIPATIONS and Mytable?

This should do it, Arun:

UPDATE c SET IsReturned = 1

FROM OPENROWSET('SQLOLEDB', 'DRIVER={SQL Server};SERVER=CSDGWEB;UID=EPP_Developer;PWD=devel0per',

EPP_Prod.EPP_Developer.ClarificationPayments) c

INNER JOIN thangela.MissingClariDb a

ON a.Paymentlot...

Change the DELETE FROM to TRUNCATE, you're clearing out all rows and TRUNCATE is non-logged.

The UNION joins together 5 different result sets before inserting them into the target table -...

Thanks Seth made me larf that did! Now, about the Lottery tomorrow...

waykna (12/9/2008)

---

Your description is about right, except that the latest (most current) n rows are used for the calculation. The function moves from the most current to the earliest...

Please don't shout, UPPERCASE is shouting.

It's...

Chirag (12/9/2008)

---

Chris Morris (12/9/2008)

---

steveb (12/9/2008)

---

SELECT top 10 * FROM [YourTable] Order by YourId Desc

It really depends on how your table is orderd, otherwise the results will not really mean...

That's the first...

last 10 records

Based on what criteria?

Arun, you seem to be a little unsure of which db (of adhoc_payge and EPP_Prod) is on a remote server. Can you clarify please? Are either of them on a...