(Ceiling(CAST((E.[MED Acct# - Participant's Annual Election]/26) as Money) * 100)/100)

Seemed to do it. Thanks for the help.

That will just round. How do I round up? Thanks!

Yeah, it puts 4 digits in. That seems a bit silly. How can you have $96.1538? I need it to represent actual money payments. Any thoughts on how I shorten...

Evil Kraig F (12/13/2011)

---

Sean Grebey-262535 (12/13/2011)

---

I kicked of a shrink (the server had run out of room), but almost an hour and a half later it is still spinning. How...

Perfect man, thank you.

Crap, apparently this is a legacy database, and even though I'm working with it with the 2008 interface, it's a 2000, so the OUTER APPLY won't work. Thanks for the...

Huh that may be my ticket,...

John Mitchell-245523 (10/18/2011)

---

If you only want one Work Order, how will you choose which one will be returned? Also, your WHERE clause includes conditions on your outer tables. ...

Ian Scarlett (9/30/2011)

---

Since you've posted this in the SQL 7/2000 forums, I'll assume you are using one of those versions, so you should be able to truncate the log with...

Thank you guys

Thanks

Turns out I had to remove and recreate my TCP/IP connection in SQL Server in case anybody else runs into this issue. Thanks for the help.

well that is surprising simple, I feel kind of stupid. Thank you.

Knock on something the files were fine and I was able to attach them and restore my data. Apparently somebody changed the password of the account SQL Server Agent was...

As luck would have it, the SQL Server agent on this box apparently got shut off a month ago, so I have no Full back up of the data that...