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