Sandeep,

here is an idea :

DECLARE VARIABLE I SMALLINT
I=0
WHILE (I<12) DO
BEGIN
INSERT INTO MYTABLE VALUES(...,DATEADD('m',I,CAST('TODAY' AS DATE)),...)
END


where DATEADD is a UDF you have to write...

Rgds,

Ignace

-----Message d'origine-----
De : Sandeep [mailto:sandeep@...]
Envoye : mardi 30 octobre 2001 04:41
A : ib-support@yahoogroups.com
Objet : [ib-support] Date Operations


I have a situation where I have to make 12 copies of record one for
each month starting from current month.

Is it possible to incerment month for a given date inside stored
proc?

Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/