Advertisement
Guest User

Untitled

a guest
May 2nd, 2016
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.69 KB | None | 0 0
  1. INSERT INTO #FuelRates
  2.     (Petrol_Band1, Petrol_Band2, Petrol_Band3, ModifiedDate, OrganisationID)
  3.     SELECT Band1 AS Petrol_Band1, Band2 AS Petrol_Band2, Band3 AS Petrol_Band3, ModifiedDate, OrganisationID FROM [FuelRates_Petrol]
  4.     WHERE OrganisationID = @OrganisationID
  5.  
  6.     INSERT INTO #FuelRates
  7.     (LPG_Band1, LPG_Band2, LPG_Band3)
  8.     SELECT Band1 AS LPG_Band1, Band2 AS LPG_Band2, Band3 AS LPG_Band3 FROM [FuelRates_Petrol]
  9.     WHERE OrganisationID = @OrganisationID
  10.  
  11.     INSERT INTO #FuelRates
  12.     (Diesel_Band1, Diesel_Band2, Diesel_Band3)
  13.     SELECT Band1 AS Diesel_Band1, Band2 AS Diesel_Band2, Band3 AS Diesel_Band3 FROM [FuelRates_Petrol]
  14.     WHERE OrganisationID = @OrganisationID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement