Sales Report with Up-Down Indicator

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

akash_singh Ten Centuries Points: 1089 More actions · Answer 1

David Burrows SSC Guru Points: 65142 More actions · Answer 2

;WITH cte (FromID,ToID,SalesIndicator,GroupNO) AS (

SELECT t1.ID,t2.ID,CASE WHEN t1.Sales < t2.Sales THEN 'UP' ELSE 'Down' END

,t1.ID-ROW_NUMBER() OVER (PARTITION BY CASE WHEN t1.Sales < t2.Sales THEN 'UP' ELSE 'Down' END ORDER BY t1.ID)

FROM sales t1

JOIN sales t2 ON t2.ID = t1.ID+1)

SELECT MIN(FromID) AS [FromID],MAX(ToID) AS [ToID],SalesIndicator

FROM cte

GROUP BY GroupNo,SalesIndicator

ORDER BY FromID ASC

Far away is close at hand in the images of elsewhere.
Anon.

akash_singh Ten Centuries Points: 1089 More actions · Answer 3

Ten Centuries

Points: 1089

December 9, 2013 at 12:25 am

Thank You...It worked!!!:-):-):-)