USE EMISRESDBMaster
GO
-- Create the Ethnicity lookup table
INSERT INTO dbo.CPRDLkupEthnicity (EthnicityCode,EthnicityDesc)
SELECT EthnicityCode,EthnicityDesc
FROM dbo.CPRDEthnicityCodesExtract WITH (TABLOCK)
-- Create the Job Category look up table
INSERT INTO dbo.CPRDLkupJobCategory(JobCategory)
SELECT JobCategoryName
FROM dbo.CPRDJobCategoryExtract WITH (TABLOCK)
-- Create consultation look up table
INSERT INTO dbo.CPRDLkupConsultationType (ConsultationType)
SELECT ConsultationTypeDescription
FROM dbo.CPRDConsultationTypeExtract WITH (TABLOCK)
GO