T-SQL Split function of comma delimited input param

Check this Split function found on Kris' Blog

Basically, pass in the stored proc a comma delimited list and it will return a temp table holding the id's