Hi ,
Its end of the season I am working on modifying the nightly procedures.
However I have got a request to add a new constituency named 'Laped Sub' for the subscriber of 07-08 and not a subscriber of 08-09 and 09-10. But this stored procedure will just add in to the Constituencies( previous year,future year and current subscriber or any combinations accordingly).
'Laped Sub'should stand unique,is there anyway I could accomplish this.
please let me know if you have any ideas , anything would be really helpful.
I just finished this it was mainly for TSTATS so that we could use the Is subscriber and Is single ticket buyer attributes . We have a Lapsed Subscriber, Current subscriber, lapsed single ticket buyer and current single ticket buyer constituencies. What I did was have a second step that runs after the LP_UPDATE_HISTORY.
The procedure checks the susb and ticket history tables respectively. Then applies the constituencies. I can provide the procedures if you would like.