if object_id ('bioRecord') is not null drop table bioRecord

select bioRecord.* 
into bioRecord
from syn_world.dbo.bioRecord
join syn_world.dbo.resource on bioRecordResourceKey = resourceKey
where dataset_uuid  in 
	('856aa56e-f762-11e1-a439-00145eb45e9a', '856f13d8-f762-11e1-a439-00145eb45e9a', '85714c48-f762-11e1-a439-00145eb45e9a', '85727f1e-f762-11e1-a439-00145eb45e9a', '857cea12-f762-11e1-a439-00145eb45e9a', 'cce04086-6c7c-11e2-90ce-00145eb45e9a', 'c18ebb72-6c7c-11e2-90ce-00145eb45e9a', 'c40738de-6c7c-11e2-90ce-00145eb45e9a', '85ad6c96-f762-11e1-a439-00145eb45e9a', '85c667c8-f762-11e1-a439-00145eb45e9a', '966426ce-f762-11e1-a439-00145eb45e9a', '7b9a08ea-f762-11e1-a439-00145eb45e9a', '7b9c52da-f762-11e1-a439-00145eb45e9a', '7e285238-f762-11e1-a439-00145eb45e9a', '81332e30-f762-11e1-a439-00145eb45e9a', '69f0f5c2-08b9-11e3-ab1f-00145eb45e9a', '02d03809-ca95-40a8-8767-3af423d1b5af', 'ab1de8e9-8a18-4ffe-b2c6-e13ffbec3e7e', 'ec81f6d4-e92f-480c-a73a-a4b71ba435cc', '7377c214-e7f1-4fc0-a9de-3b85728ccc11', 'ee0e7875-8fbc-4cd8-a6a8-65f4a871e2ea')
