I wouldn't make that...

Matt Miller (6/20/2008)

---

Isn't performing a remote (linked server) update going to serialize the update into cursor-like updates?

It seems to me you'd want to encapsulate and send the update statement (via...

Isn't performing a remote (linked server) update going to serialize the update into cursor-like updates?

It seems to me you'd want to encapsulate and send the update statement (via OPENQUERY) ...

My gut reaction is: pick your battles. Don't take that kind of attitude head-on. Braggarts will continue to do so no matter what, so just look past it.

Instead...

If you were to use either DAO or ADO with the VBA scripting options, you can tap into the Querydefs collection, which would have SQL code behind the Access queries....

Jeff Moden (6/20/2008)

---

rbarryyoung (6/20/2008)

---

Try this:

SELECT Metal, min(Result), max(Result), count(Result), stdev(Result)

FROM Metals

GROUP BY Metal

By the way, stdev() is the statistical standard deviation, if you want the standard deviation for...

Sounds to me that even once you have your data organized, you have the probably non-trivial task of making sure you have conversion scenarios between unit notations. You're also...

I'd say perhaps take a look at how much of each you happen to do. There's often something you do more than others, so perhaps that should be your...

Then before worrying about the merge or upsert, focus on figuring out how to bulk load that data into a temp data used for staging. We've got...

Why would you ever do that kind of process one row at a time? turning an upsert (which is a pet name for what this kind of operation is)...

Can you change the scope of grouped totals?

1. A user needs a report where they can dynamically query an invoice table for total invoices between specific dates. Walk...

It does help if I put in the correct scale for the numerics. This does seem to work (just adding in test data and fixing the scales to show...

True....but some of it really is stuff that just isn't documented. Those things make it awfully hard to throw out things outright, and force you to test them.

Like this...

In 2005 this would be easy to define as a user-defined aggregate, or a "regular" T-SQL function as well. You'd have to pass in a way to know which rows...

Jeff Moden (6/19/2008)

---

Matt Miller (6/19/2008)

---

Actually - the other person was me, and the comment centered around the "locking TempDB" urban legend that seems to pop up a lot. That...