SQLServerCentral Article

TSQL Challenge 82 - Find elements that uniquely make up a group

,

TSQL Challenge 82 - Find elements that uniquely make up a group

The challenge is to find the Tax Code based on Price. There is a table called "LineItems" that have Invoice Number and Price. There is another table "Sales" contains Invoice Number, Amount and Tax Code. Each sales amount is uniquely made up by the sum of one or more prices. Based on this you should assign the tax code to each price.

http://beyondrelational.com/puzzles/challenges/116/find-elements-that-uniquely-make-up-a-group.aspx

Rate

1.67 (3)

You rated this post out of 5. Change rating

Share

Share

Rate

1.67 (3)

You rated this post out of 5. Change rating