Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO #FuelRates
- (Petrol_Band1, Petrol_Band2, Petrol_Band3, ModifiedDate, OrganisationID)
- SELECT Band1 AS Petrol_Band1, Band2 AS Petrol_Band2, Band3 AS Petrol_Band3, ModifiedDate, OrganisationID FROM [FuelRates_Petrol]
- WHERE OrganisationID = @OrganisationID
- INSERT INTO #FuelRates
- (LPG_Band1, LPG_Band2, LPG_Band3)
- SELECT Band1 AS LPG_Band1, Band2 AS LPG_Band2, Band3 AS LPG_Band3 FROM [FuelRates_Petrol]
- WHERE OrganisationID = @OrganisationID
- INSERT INTO #FuelRates
- (Diesel_Band1, Diesel_Band2, Diesel_Band3)
- SELECT Band1 AS Diesel_Band1, Band2 AS Diesel_Band2, Band3 AS Diesel_Band3 FROM [FuelRates_Petrol]
- WHERE OrganisationID = @OrganisationID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement