SELECT carrierID, carrier, countryCode, country, prefix, suffix, active FROM #variables.tableprefix#carriers WHERE 0 = 0 AND carrierID = AND active = 1 ORDER BY countryCode, carrier INSERT INTO #variables.tableprefix#carriers (carrierID,carrier,countryCode,country,prefix,suffix,active) VALUES ('#createUUID()#', , , , , , ) UPDATE #variables.tableprefix#carriers SET carrier = , countryCode = , country = , prefix = , suffix = , active = WHERE carrierID =