begin

declare @seq_no char(09)

declare @cdate  char(06)

declare @ccount char(03)

declare @rdate  date

declare c1 cursor for select  convert(char(6),WRIT_DATE, 112)

,WRIT_DATE from old_notice for read only

open c1

fetch c1 into @cdate, @rdate

while  (@@sqlstatus !=2 )

begin

                       select  @ccount =  replicate ('0',3-char_length(convert(varchar,count(*)+1)))+convert(varchar,count(*)+1)

                      from new_notice  where convert(char(6),WRIT_DATE, 112) =  @cdate

                      insert into new_notice values (@cdate+@ccount, @rdate)

close c1

deallocate cursor c1