DROP TABLE Dataset_Demand_Test

 SELECT *
 INTO Dataset_Demand_Test
 FROM dbo.vwSODemand
 UNION ALL
 SELECT *
 FROM dbo.vwOODemand

------Dataset_EstockInventory
 TRUNCATE TABLE Dataset_EstockInventory_Test

 INSERT INTO Dataset_EstockInventory_Test
     EXECUTE dbo.ESTOCKInventory

 ----Dataset_GlobalPosition

DROP TABLE Dataset_GlobalPosition_Test

SELECT *
INTO Dataset_GlobalPosition_Test
FROM vwGlobalPositionV2

------Dataset_GrowerInformation
TRUNCATE TABLE Dataset_GrowerInformation_Test

INSERT INTO Dataset_GrowerInformation_Test
    EXECUTE dbo.GrowersReport_SSRS