Fill Result Table with Sale Brackets

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » Fill Result Table with Sale Brackets

Fill Result Table with Sale Brackets

Rate Topic

Display Mode

Topic Options

Author

Message

Jako de Wet

Posted Wednesday, February 06, 2013 3:20 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, April 11, 2013 2:25 AM
Points: 85, Visits: 137

Hi there

I have a table of sales that has a ItemID, Quantity and Value of the sale.

Say for week 1, I have total sales of $100 000, I want to have a result of 5 brackets of $20 000 each to make up the total of $100 000. In essence, it took X amount of items to fill up the first $20K, Y amount to fill up the next $20K and so on.

I am busy creating a cursor that will loop through all the sales and create a result table with
bracket1, ItemID, Quantity
....
bracket5, ItemID, Quantity

It feels very cumbersome and was wondering if there isn't a quicker way?

Post #1416365

« Prev Topic | Next Topic »

Permissions