Dalton Moore (7/28/2011)

---

Rod at work (7/28/2011)

---

When I first saw the title of your editoral, I had to laugh. No, I can't telecommute; at least not in my current position....

When I first saw the title of your editoral, I had to laugh. No, I can't telecommute; at least not in my current position. It's not even open...

Another great topic, Steve. In looking at most people's responses, it appears to me as though most of us struggle with interruptions. Where I work, it's just a...

GSquared (7/25/2011)

---

It's also important to keep in mind what the cost-of-living index is in your area.

I make the national average for my experience, but I make a third again as...

Thank you very much, Sean!

Sorry, Sean, I'm getting hammered today. OK, here's a couple quick inserts to get the Vouchers and MoneyPools tables populated.

insert into Vouchers

values (10000, 149566, 1, 4000.00, 150.00)

insert into Vouchers

values...

cengland0 (7/22/2011)

---

Rod at work (7/22/2011)

---

A large part of that is because I work for a university; have for the last 15 years. Universities always pay less than the private...

Good question for a Friday, Steve. My short answer to your question is, no. I don't really know my market value is in my local area. A...

Correct, the AmountExpended column cannot exceed the VoucherCap.

Correct, the AmountInvoiced and GrossReceiptsTax, summed together gets added to the voucher and moneypools table. Here are the other 2 tables. Note: I've only included relevant columns:

CREATE TABLE [dbo].[Vouchers](

[VoucherNumber]...

Sean Lange (7/21/2011)

---

You can't pass a stored procedure to a function. You could pass the results of a stored procedure to a function if you wanted. Based on what you...

Elliott Whitlow (7/21/2011)

---

How many records are we talking about here?

You certainly can do this row by row, however that method of processing is substantially slower than a set based solution....

Steve Jones - SSC Editor (7/20/2011)

---

Rod at work (7/20/2011)

---

I appreciate this article, Steve, as it's something I have faced for the last 3 years. No training, no conferences, etc....

I appreciate this article, Steve, as it's something I have faced for the last 3 years. No training, no conferences, etc. However, in my situation it isn't so much...

I totally agree with you, Andy. I'm one of those accidental DBA's. We're a small IT shop (used to be 4 of us, but we've lost 1 recently...