Thanks for everyone who is invloved.

dense_rank did work.

Here is what I am expecting. I am listing only 2-3 records per month, in real I get 30/31 records per month.

(day_date) (year_num) ...

Try this and see if it works

select INFOR.TRAIN.IMSV7.EMPLOYEE.EMPID

from INFOR.TRAIN.IMSV7.EMPLOYEE

Thanks for all of your efforts. I got what I was looking for.

How about writting a trigger to maintain new temp kind of table on same server and same database.

On nightly basis use BCP to port data to different server.

Populate new column into temp table by set based SQL and then insert desired usernames by selcting distinct values from temp table.