Use [outpost]
-- DROP TABLE [outpost].[pilot_gillaspy].[tbl_obs_2]
SELECT * INTO outpost.pilot_gillaspy.tbl_obs_4
FROM (
	SELECT -- TOP (1000)
		centricity.PERSON.PID,
		centricity.PERSON.DATEOFBIRTH,
		centricity.PERSON.SEX,
		centricity.PERSON.ETHNICITYMID,
		centricity.PERSON.RACEMID,
		centricity.OBS.HDID,
		centricity.OBS.OBSDATE,
		centricity.OBS.OBSVALUE,
		centricity.[DOCUMENT].LOCOFCARE
	FROM centricity.OBS
		INNER JOIN centricity.PERSON ON centricity.OBS.PID = centricity.PERSON.PID
		RIGHT OUTER JOIN centricity.[DOCUMENT] ON (centricity.OBS.PID = centricity.[DOCUMENT].PID) -- AND (centricity.OBS.SDID = centricity.[DOCUMENT].SDID)
	WHERE (
		centricity.[DOCUMENT].LOCOFCARE IN (1466943000000650, 1466943030000650, 1473775138000700, 1696769819014460))
		AND (centricity.OBS.HDID IN 
			(
				55,   -- height E&M - 8302-2
				3094, -- height in centimeters E&M
				61,   -- weight E&M - 3141-9
				3095, -- weight in kilograms E&M
				2788  -- Body Mass Index [Ratio]
			)
		)
		AND (convert(datetime, '2008-01-01', 110) < OBSDATE )
) as tbl_temp

ORDER BY PID,OBSDATE, LOCOFCARE, HDID, OBSVALUE

--takes 4:33 min; (37140446 row(s) affected)
