Esther,<br><br>In which language would you like the script done ? Secondly, is there a specific reason why &#39;month&#39; and &#39;year&#39; would occupy their own separate columns ? the `datetime` type already accounts for the year-month-date hr::min:ss .<br clear="all">
--<br>Ndungi Kyalo<br><a href="http://biblia.kenya.or.ke">biblia.kenya.or.ke</a><br><br><br>
<br><br><div class="gmail_quote">On Wed, Jan 27, 2010 at 11:54 AM, wambugu esther <span dir="ltr">&lt;<a href="mailto:essiekui@gmail.com">essiekui@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div><br clear="all">Hi skunkworks,</div>
<div>kindly help me <br>i have a table with  these columns<br>(<br>month int  null,<br>year  int not null,<br>acct_no char(15) not null,<br>acct_type char(10) not null,<br>effective_dt datetime null,<br>late_fee_to_dt)<br>

<br>the field effective_dt is null and i want it to be populate by a value which d=should be composed of &#39;29&#39; then the respective value of column month and respective value of column year,<br>kindly help me do a script to update the effective_dt.<br>

<br>will appreciate your assistance<br>-- <br><br><br>Best regards<br>Esther Wambugu<br><br></div>
<br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Server donations spreadsheet<br>
<a href="http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en" target="_blank">http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en</a><br>

------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br>
Other lists<br>
-------------<br>
Announce: <a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce</a><br>
Science:  <a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/science" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/science</a><br>
kazi:     <a href="http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general</a><br></blockquote></div><br>