Mike, it would be nice if you'd pay some attention to the name of the forum.
It's on top of the page, between "Home" and "T-SQL".
There is no point to repeatedly post SQL2005 solution not appropriate to SQL2000 on this forum.
_____________
Code for TallyGenerator