I have 3 Insert statements which are dependently written as views and I have to run these views manually..
I want to automate this process - How can I achieve this? Write a Script ?
The 3 views are shown below;
INSERT INTO dbo.CPRDLkupEthnicity (EthnicityCode,EthnicityDesc) SELECT EthnicityCode,EthnicityDesc FROM dbo.CPRDEthnicityCodesExtract WITH (TABLOCK)
INSERT INTO dbo.CPRDLkupJobCategory(JobCategory) SELECT JobCategoryName FROM dbo.CPRDJobCategoryExtract WITH (TABLOCK)
INSERT INTO dbo.CPRDLkupConsultationType (ConsultationType) SELECT ConsultationTypeDescription FROM dbo.CPRDConsultationTypeExtract WITH (TABLOCK)
Thank you so much