I'm...

George, I'm getting a 9.00.3068.00 when I run the @@version.

George, it is a rather large .LOG file (~ 9 MB in size), and I see several errors in it, even at the beginning. However, I will assume that...

Lynn Pettis (7/3/2008)

---

Though I didn't respond to your original post, I assure you, not a problem. Sometimes asking for help is all it takes. In asking for help,...

OK, this is very weird, but I just re-ran my query again, summing all of the Amounts and GrossReceiptsTax added together, against the fund, and it came out exactly to...

You're right, I did forget to mention the data types. In the MoneyPools table both the AnnualAllocation and the RemainingValue columns are of type money.

In the Vouchers table the...

Mani Singh (6/25/2008)

---

Go with the first approach of changing the size of datatype, but avoid using MAX it is a BLOB type equivalent to text in earlier versions.

so use it...

Steve, in your editorial you said,

"TechEd is still disappointing for me this year, with about 6000 people instead of the 11,000+ there has been in the past. That many people...

OK, that was it. WOW, I feel so stupid; the answer is so obvious.

Oh well, thank you everyone for helping me out of my brain fart.

Thank you for the feedback everyone. I didn't realize that the format they were using was an old SQL standard (with *=, =* and so on). I'll try...

WOW, thanks Antonio and SteveB! Your two answers gives me exactly what I'm looking for and now I can make an informed decision. I really appreciate it!

OK, thank you, Scott.

Scott, what did you do to fix it? Did you run DBCC UPDATEUSAGE?

Thank you, Grant.

Prasad Bhogadi (1/28/2008)

---

Hello Rod,

Thank you for the comments, I see what you were doing! You tried to generate the stored procedure for a table that has no Identity defined and...