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...

Boy, Steve, you nailed this one! I work in an industry closely related to healthcare (it isn't really, but there are similarities), and our budget is shrinking constantly (20%...

Ron Porter (6/8/2011)

---

I have a question related to the fact that there seems to be a lot of demand that programmers have a bunch of their own work to show...

This is a tough question. I work for a university, and when I've been involved in interviewing people for open positions I've learned how hard that is. For...

Good points, Steve.

I agree. Some other word would probably have done...