How about using recursion :hehe: to replace loops? (One of the great new functions in SQL2005)

No need for a tally or temporary tables.

Heres a params example:

DECLARE @params varchar(8000)

SET...