Repeat chunk of data got from select statement multiple times

Question

1)I have the following query

select CRESTACode,Latitude,Longitude   from airgeography..tgeography where countryname in (
'St. Maarten') and crestacode is not Null

Result:

CRESTACode  Latitude    Longitude
6           18.035187    -63.076599

How do I repeat this data multiple times to get 3000 rows of same data in a table ?

Duplicate? http://stackoverflow.com/questions/2472662/make-sql-select-same-row-multiple-times — Dmitry Sadakov, Apr 28 '15 at 16:41

score 0 · Accepted Answer · answered Apr 28 '15 at 16:46

although it could be expensive:

DECLARE @InsertNum INT 
SET @insertnum = 3000

select CRESTACode,Latitude,Longitude   
INTO #tablex
from airgeography..tgeography 
where countryname in ('St. Maarten') 
  and crestacode is not Null 

WHILE (@InsertNum <> 0 )
    BEGIN 
        INSERT INTO #Tablex 
        SELECT CRESTACode,Latitude,Longitude 
        FROM Tablex;

        SET @insertNum = @InserTNum - 1
        Print @InsertNum
    END 

SELECT * FROM #tablex

Repeat chunk of data got from select statement multiple times

1 Answers1