I sure wish that forums could be put into one's briefcase. This one would definitely qualify.

Bill,

Thanks for the table DDL/DML; however you still haven't specified what the desired output should look like, so I'm making a WAG here. Let us know if this works for...

The entity known as "The Thread" randomly deducts...

Roy - what did you think of all the April 1st jokes on this site? Steve pulled off some pretty awesome ones

Barkingdog (4/12/2010)

---

I work with a dev who would lke the following permissions on several databses, on different servers (sql 2000, sql 2005, sql 2008). Is his request a reasonable one...

The "Holy smokes" is adequate... this routine that...

abemby (4/13/2010)

---

Hi Adam

I did mention that this is done after database is backedup... i completely agree with you... may be i should have highlighted it in bold.

... >> A...

You might want to read this article[/url] by Gail Shaw of why you shouldn't truncate logs.

There are a few methods, but none of them are pretty. Note that in SQL 2008, you can pass a table variable to a procedure, but since this is a...

You cannot add a column to a table at a specified column position; adding a column adds it to the end of the table.

If you really need this column in...

You will have to:

1. drop any foreign keys in other tables referencing this index if applicable.

2. drop the index

3. change the column

4. rebuild the index

5. reinstate any foreign keys that...

Matt Miller (#4) (4/12/2010)

---

Also - does it matter which blocks get consumed first in the case of a tie? For example - if batches 1,3,6,8 each had 100 and...

Jeff Moden (4/12/2010)

---

Heh... I was just getting ready to post a nearly identical solution. I'm pretty proud of you guys... you beat me at my own game anymore. :-P...

Absolutely. Based on these clarifications, this will work for you.

SET NOCOUNT ON

if object_id('tempdb..#tDivision') IS NOT NULL DROP TABLE #tDivision

if object_id('tempdb..#tDivisionBloc') IS...

You didn't give us all the information we're going to need in order to help you.

For instance, does "highest weight" = #tDivisionBloc.BlocWeight?

Does "Qty" = #tDivision.DivisionQty, or #tDivisionQty * #tDivisionBloc.BlocWeight?

Based upon...