Aquasys

SELECT
a.*,
DATEFROMPARTS(
YEAR,
11, -- new month number
DAY
) AS NewReadingDate
FROM PreBillDetails a
JOIN MeterReadingAreas b ON b.MeterReadingAreaID = a.AreaID
JOIN Contacts c ON a.MeterReaderID = c.ContactID
WHERE a.AreaID = 29
AND a.BillDate >= '2025-12-01';

UPDATE a
SET a.readingdate = DATEFROMPARTS(
YEAR,
11, -- new month number
DAY
)
FROM PreBillDetails a, MeterReadingAreas b, Contacts c
WHERE a.MeterReaderID = c.ContactID
AND b.MeterReadingAreaID = a.AreaID
AND a.AreaID = 29
AND a.BillDate >= '2025-12-01';