Yes, transaction can qualify more than once. Quantities are allocated to the groups that yield the most $ amount.

The quantities mean the same thing.

This topic was re-posted in the TSQL 2012 forum.

Please use this link to the new location: http://www.sqlservercentral.com/Forums/Topic1511715-3077-1.aspx

/*Here is the DDL and sample data. */

--Create and Insert for EventSkuGroup

CREATE TABLE [dbo].[EventSkuGroup](

[EventID] [int] NOT NULL,

[GroupID] [int] NOT NULL,

[SKUNumber] [int] NOT NULL,

[GroupMinQty] [int] NOT...

Admin, please move this post to the TSQL 2012 forum. I just realized that it was posted in 2K5.