----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: kals_j Message 1 in Discussion hi, table name: Card_Details Column names and respective data types Card_Number - Varchar Current_Card_Issue_Date - Datetime Valid_Until_End - Varchar table name: Card_Types Expiry_Reissue_Adv_Period - Decimal table name: System_date sys_date - datetime Current card expiry date(i.e. Valid until end) combined with the day value from the current card issue date (dd) minus the card type expiry reissue advance period is less than or equal to the current system date Example Current card issue date: 18/05/2001 Card type expiry date: 200405 Card type expiry reissue advance period: 28(Days) Trigger date for new card issue to be generated: May 2004 with a day value of �18� � 28 days = 20 April 2004 So, this card must be read for expiry reissue processing when the system date is 20 April 2004, or the nearest working date after. At that time, all other cards with a calculated trigger reissue date less than or equal to (<=) 20 April 2004 must also be read for expiry reissue processing. Need to implement this using view which should return card_number. Thanx in adv Kals ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
