Nopes it would not be. However have modified the solution provided to use CTE. works well now irrespective of the order of data input.

delete from agegrp;

insert into agegrp values (0);

insert...

Hi anybody able to help me out on this?

Rgds,

Anand.

Hmm... but if my levels of nesting is multiple and if i need to abort if error occurs at any level then i guess i would have to settle for...

Thnx folks for the replies!