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.