testCohort.sql

--simple cohort
DROP TABLE IF EXISTS ##COHORT;

CREATE TABLE ##COHORT (EMPI VARCHAR(90) NOT NULL);

INSERT INTO ##COHORT (EMPI) values
('8001111117'),
('1000000000'),
('8333333002')
;

SELECT * FROM ##COHORT;

DROP TABLE IF EXISTS ##RADCOHORT;

SELECT ##COHORT.EMPI EMPI_GIVEN INTO ##RADCOHORT FROM ##COHORT;

SELECT TOP 2 * FROM ##RADCOHORT;