Unfortunately, no. Something like that just might be useful but not sure how it would be implemented.

I would also look at increasing the frequency of your transaction log backups from every hour to every 15 minutes. I would also consider adding an alert that would...

Too Cool!!

I agree, great way to mess with someones head.

As long as you remember this one Cardinal Rule:...

Bruce W Cassidy (5/20/2009)

---

Jeff Moden (5/20/2009)

---

Take Lynn's original advise... The third operand of ROUND will allow you to truncate instead of round. Heh... look it up in Books Online....

Here is one I found with a Google search, http://www.mymathforum.com/.

If that one doesn't work, try Google to find some more.

john.arnott (5/20/2009)

---

Jan asks

I thought of that but didn't dare dip my toe in that pool. How funny would it be...

nimmi.smith (5/20/2009)

---

Lynn: You hit the nail right on the head. That is exactly what he is looking for.This is a tiny shop. There is no front-end developer. Just myself...

I have to make a plug here. If you find yourself needing to go to compressed backups, look at HyperBac. It can be installed and configured to compress...

nimmi.smith (5/20/2009)

---

He has multiple box sizes and multiple bottle sizes. I will have him give me the the physical dimensions of the bottles, not their volume and repost the...

I'm going to have to...

I'm beginning to wondor if the OP has even checked this thread. I haven't seen anything since the original post.

And another thought, you may need to use advanced math (calculus) if you are trying to maximize the number of bottles per box. With that, these calculations should probably...

Okay, that one looked like a nitrogen frozen, napalm soaked porkchop to me...

Given the proper information it should be possible to create a function/procedure to complete the necessary computations. Is there only one size box or do you have multiple sizes...