I have a collections software that is written in Sybase and I am having a hard time finding the right command. What I am trying to do is have Sybase total or sum the amount of accounts in a table and then be able to divide them equally over a 30 day period. I just cannot find the right syntax to do this. Our collection software company states that it cannot be done. Can someone please help me out?
What I am trying to do is update the database so, the next contact date for the account is changed based on the amount of days in the month. So, what I am looking to do is the following.
Say I have 400 rows in the table and I would like to take those rows or accounts in this example over a period of 30 days. So I would first take 400/30 to equal 13 accounts per day. Now I want to take those results and place those 13 accounts equally over the 30 days through an SQL statement. I have the statement already for finding the amount of accounts or rows in the table, but I do not know how to have Sybase move those rows or accounts equally over the 30 day period.