new table from old

copy from one table to another, with sampling

select * into table1X from tableX tablesample (10 percent) 
-- 10% of the page space, not rows
select * into table1X from tableX tablesample (1000) 
-- 1000 lines, not the same
select * into table1X from tableX tablesample (10 percent)    repeatable (205) 
-- returns same values

quick way to copy a table into another table.  Also, of course, can create the table first, then use insert rather than select.

Advertisements