11-28-2013 04:07 PM
This is some what difficult to explain for me.
I works for a credit card company. I have to built a code in which I have to keep a track that for a single card a service can be applied 10 times only at a time
11-28-2013 04:12 PM
No, please post here if you have a question, so others can see the response.
Unless you're paying me, I prefer online public discussions.
11-28-2013 04:33 PM
I am getting a file from in which I am getting card number, transaction id as a variable. Each sevice has some starting date and some end date. I have to keep a track that only 10 service should activate at a time.
for first time I have to assign service1 - service 10 in a round robin way. That I have done.
Next time when I will get the same cardnumber and transaction id, I have update that with the previous record which I got from earlier file. That is also covered by me.
I got stuck in condition where if a new record came with same card number but different transaction id then I have to put a service value which is not in earlier records. Their can be a multiple records for single card number in one file.
please help me on this.
11-28-2013 05:56 PM
Create a master table that lists each card and the current status/number.
Increment and decrement this file as each file comes in.