Instead why don't you create a simple procedure for calculating the interest
which get invoked automatically at the start of the month.
This procedure can be scheduled to be executed in the beginning of the
Hope this helps.
>From: "Gerard G Chua" <marvmarv@e...>
>Reply-To: "sql language" <sql_language@p...>
>To: "sql language" <sql_language@p...>
>Subject: [sql_language] Re: Is there any way to know the end of month?
>Date: Wed, 13 Dec 2000 22:43:56 +0800
>i am not sure on the commands but you can use this algo
>increment the month by 1 then go to its 1st day them minus 1
>sql language wrote:
> >I am going to made a stroed procedure which calculates interest at every
> >end of month.
> >Is there any way to know the end of month?
You are currently subscribed to sql_language as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-sql_language-$subst('Recip.MemberIDChar')@p2p.wrox.com