That did it. Everything looks good now. Just need to clean up the CT wiring in the garage and I'd say everything is done.ben wrote: ↑Mon May 01, 2023 1:37 pmTry
INSERT INTO hourdata (channel_id, date, wattsecond, watt, kwh, seconds, cost, totalcost, amps, peakwatt, minwatt)
SELECT '2386', date, wattsecond, watt, kwh, seconds, cost, totalcost, amps, peakwatt, minwatt
FROM hourdata
WHERE channel_id = 2341
AND date < (select min(date) from hourdata where channel_id = 2386);
Thanks again for all the help. Much appreciated!