Craig Farrell (12/11/2010)

---

WayneS (12/11/2010)

---

Craig,

Edit: Whoops, this plan is for the update in the cursor, not the initial 6 hour one. Still, it is taking about 8 minutes per batch -...

Employee was expected to work for 10 hrs (1800-0800), but actually worked for 9.26, leaving a shortage of .74 hours. What's the issue here?

(Actually, worked will be 9.566666 (work 9:34:...

You need to look at the two articles in my signature that deal with Cross-tabs/Pivot Tables (parts 1 and 2) - I think that these will get you what you...

This article walks you through it[/url]. Post back if you have any questions.

Craig Farrell (12/10/2010)

---

WayneS (12/10/2010)

---

Is it just me, or do others also see that the quantity of technical posts has dropped considerable lately? I know all the schools are closed, but...

Craig,

Any chance of getting an execution plan on that first update (the 6 hour one)? Also, can we get updated Delete/Insert/Update plans after you implement the 3rd suggested index from...

Craig,

When I opened the update plan, what immediately popped out at me is a missing index on the staging table with an impact of 80%!

The suggested index to make on...

Is it just me, or do others also see that the quantity of technical posts has dropped considerable lately? I know all the schools are closed, but there were good...

FargoUT (12/10/2010)

---

This was an excellent article! I even forwarded it on to the manager of a company who was asking me for help in determining what sort of skill requirements...

Craig Farrell (12/10/2010)

---

WayneS (12/10/2010)

---

CirquedeSQLeil (12/10/2010)

---

jcrawf02 (12/10/2010)

---

CirquedeSQLeil (12/10/2010)

---

Alvin Ramard (12/10/2010)

---

WayneS (12/9/2010)

---

Bummer... user group was locked...

CirquedeSQLeil (12/10/2010)

---

jcrawf02 (12/10/2010)

---

CirquedeSQLeil (12/10/2010)

---

Alvin Ramard (12/10/2010)

---

WayneS (12/9/2010)

---

Bummer... user group was locked out of their...

This should handle it for you. It shows every combination of the Qty field that when added to every other combination, comes up to 50.

-- See how you start off...

Check out this article[/url]

Craig Farrell (12/10/2010)

---

Plenty of hope, I've been at this ten years or so, Wayne longer. Give yourself time. Eventually you remember the functions offhand and then start coming up...

But of course! :w00t:

What hope is there for us normal...