--Create the original array (table 
CREATE TABLE 
DECLARE @n INT SET @n=1
while @n<=10 BEGIN INSERT INTO 

--Select the subset that are even into the new array (table 
SELECT v INTO 

-- Show 
SELECT * FROM 

-- Clean up so you can edit and repeat:
DROP TABLE 
DROP TABLE