Skip to Content
0

Week Numbers in Period

Dec 01, 2017 at 12:12 AM

28

avatar image
Former Member

Hi,

I need to rank week numbers partitioned by fiscal period and also get total number of weeks in a period for Date

For example:

Period-Week-WeekRank-NumWeeks
201701-01-1-4
201701-02-2-4
201701-03-3-4
201701-04-4-4
201702-05-1-3
201702-06-2-3
201702-07-3-3
201703-08-1-5
201703-09-2-5
201703-10-3-5
201703-11-4-5
201703-12-5-5

Sor of like doing Rank () over (Week ORDER BY PERIOD)

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers