ah. row number w partition. nice. i was about to cross apply it to itself to get the darn id to reset. thanks