This might be kinda similar to one of the responses above. Cursor usage is bad ... but works..

---------------------------------------------------

SET NOCOUNT ON

DECLARE @val varchar(25)

CREATE TABLE Temp(ID int PRIMARY KEY IDENTITY(1,1),...