THANKS, andy and steve for ur quick responses, yes i am using sql 7.0

and steve i am not clear about ur suggestion. u mean to say that i should...

Andy where do i look for the GETUTCDATE() function tried BOL but no help i found there.

thanks for the reply

keyur

Andy and Steve, thanks for the feedbacks

but finally this code for proc worked perfectly

create procedure daily

as

insert into...

thanks andy and steve for ur feedbacks,

well i have to run the storedproc every morning when the data entry has not started

and the select is running alone also it...