Minor Correction: > Select > Min(Id) as Next > From <table> > Where Id > @SelectedID > And Parent_Id = @SelectedParentID Forgot to flip the ">" sign. -- Anthony Baratta "When life becomes an extended picnic, with nothing of importance to do, ideas of greatness become an irritant." -- Charles Murray