Wednesday, 2 June 2010

Treasury Account Head Problem

Download and  run attached exl.  ( Download )

execute the attached script using script tool.
if the accountheads are required for the current date execute the following:

use treasury
go
update_megh66_accountheads

if the accountheads are required for a particular date:


use treasury
go
update_megh66_accountheads_bydate 'ddmmyy'


in this ddmmyy explanation is as follows:
if the date is 02/06/2010 then it will be equal dd/mm/yyyy so the ddmmyy will be 020610. This can be applied to any date on the same analogy.

1 comment:

  1. KINDLY ALSO POST A DETAILS OF IPO EXAMINATION--
    THAT 1-HOW MANY PAPERS ARE BEING TAKEN.
    2-WHICH PAPERS CONTAIN WHICH VOLUMS(BOOKS)FROM WHERE IT CAN BE PURCHASED.
    3-UNSOLVED PAPER OF THIS EXAMINATION OF TEN YEARS.

    OR TELL ME ANY OTHER WEBSITE ABOUT THESE CONCEPT.

    SYSTEM MANAGER
    FAIZABAD-224001

    ReplyDelete