Lynn Pettis (3/8/2010)

---

Matt Miller (#4) (3/8/2010)

---

Michael Valentine Jones (3/8/2010)

---

Matt Miller (#4) (3/8/2010)

..I've actually received calls from previous employers demanding I drive into work WHILE the state has a state of...

Michael Valentine Jones (3/8/2010)

---

"previous employers" ...

KevinC. (3/8/2010)

---

For the record, I don't drink. 😎

To answer Steve's question, I think anyone, if unable to drive and not on call, should be allowed to not come in....

Gary Varga (3/8/2010)

---

All fair comments as far as regulators go, however, before the Royal College of Surgeons demanded certain qualifications, mere barbers would drill into peoples heads. This barbaric period...

Alvin Ramard (3/8/2010)

---

When it comes to the thread, MCP could stand for: Multiple Crappy...

Lynn Pettis (3/3/2010)

---

greg-877697 (3/3/2010)

---

I've been a SQL DBA since 1998, never taken a certification test. My resume speaks for my qualifications, not a test of theoretical knowledge that many...

aaron.reese (3/3/2010)

---

That sounds like good coding to me.

All of the business rules about how data gets validated and entered into the table is held in the SPs.

Any user interface gets...

keep in mind that lutz' version will keep the identity on the deed_id column. Given the usage you're describing it shouldn't make a diffierence, but this means the...

Stats get used during execution plan building and validation, so bad stats usually = bad exec plan.

If for example it underestimated how many records might be affected, some of your...

Since you're using a temp table - you will want to add a clustered index in order to make the running totals work.

You should start by reading Jeff's article on...

Depending on how you have your Access set up - Access can be pretty brutal on IO, so at very least see if you can use separate drives/LUN's, so you...

Yes - you could store it as XML and pass that in, or like you mentioned - pass it to a for each loop (using the...

Once you do that - configure the foreach loop to pull data from an ADO enumeration, then point to the variable you pre-loaded. index 0 = column 1 of...

You could try simply capturing the output from your first stored proc to an SSIS variable, and pass it to the second stored proc as a parameter.....

Les Cardwell (3/2/2010)

---

In context, it was in reponse to Steve's posit...

...In the paper world, when someone generates a duplicate PO number it may or may not get corrected, and may...