SQLServerCentral Article

TSQL Challenge 76 - Identify the sequence of accounting transactions

,

TSQL Challenge 76 - Identify the sequence of accounting transactions

The challenge is to identify the sequence of accounting transactions. The table has data which is ordered. You need to follow the order of the data, and detect a certain condition which lasts for a sequence of data rows, you need to give these data points a common which uniquely identifies the sequence, possibly together with other keys in the data.

http://beyondrelational.com/puzzles/challenges/110/identify-the-sequence-of-accounting-transactions.aspx

Rate

Share

Share

Rate