Actions
Support #77
closed
Area not downloading
Description
area ontikatte reading date 11
meter reader prathik
Actions
Added by Anju Mathew 3 months ago. Updated 2 months ago.
Description
area ontikatte reading date 11
meter reader prathik
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';