Each time you run 'INSERT INTO temp1 ' you create a new record. Try the following code.:

create table myTemp (col001 varchar(250))

insert into myTemp values ( 'this is some text' )

insert into myTemp values ( 'this line 2 of text' )

insert into myTemp values ( 'this line 3 of text' )

insert into myTemp values ( 'this line 4 of text' )

create table #Temp1 (col001 varchar(250))

DECLARE @col001 varCHAR(255)

DECLARE @COL002 varCHAR(255)

DECLARE csrSites CURSOR FOR

SELECT col001 FROM myTemp

OPEN csrSites

FETCH NEXT FROM csrSites INTO @Col001

FETCH NEXT FROM csrSites INTO @Col002

WHILE @@FETCH_STATUS = 0

BEGIN

INSERT INTO #Temp1 (col001) values (@Col001 + @Col002)

FETCH NEXT FROM csrSites INTO @col001

FETCH NEXT FROM CSRsITES INTO @COL002

END

SELECT *

FROM #Temp1

CLOSE csrSites

DEALLOCATE csrSites