phickey (5/13/2011)
msaleem-583379 has a pretty good function.
Where is that? What is the URL? I don't see such an entry on this thread.
And, for the record, the "performance issue" with the Tally Table has very successfully been put to bed for VARCHAR(8000) and NVARCHAR(4000). Please see the following article...
http://www.sqlservercentral.com/articles/Tally+Table/72993/
And, yes, I realize I'm responding to a post that is responding to a two year old thread. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.