
SELECT DIGYR 
	--, (SELECT SUM(ESTTAX) FROM DBO.TAXDETAIL T      INNER JOIN PROPERTY P ON P.PROPERTYKEY=T.PROPERTYKEY AND P.TAXDISTRIC='03' WHERE TAXTYPE=6) BELLEMEDE_TOTAL
	--, (SELECT SUM(ESTTAX) FROM DBO.TAXDETAIL_LOG L  INNER JOIN PROPERTY P ON P.PROPERTYKEY=L.PROPERTYKEY AND P.TAXDISTRIC='03' WHERE TAXTYPE=6 AND CONVERT(DATE,LOG_DATE)='20240401') BELLEMEDE_TOTAL_20240401

	--, (SELECT SUM(ESTTAX) FROM DBO.TAXDETAIL T      INNER JOIN PROPERTY P ON P.PROPERTYKEY=T.PROPERTYKEY AND P.TAXDISTRIC='03' WHERE TAXTYPE=7) NORTHVIEW_TOTAL
	--, (SELECT SUM(ESTTAX) FROM DBO.TAXDETAIL_LOG L  INNER JOIN PROPERTY P ON P.PROPERTYKEY=L.PROPERTYKEY AND P.TAXDISTRIC='03' WHERE TAXTYPE=7 AND CONVERT(DATE,LOG_DATE)='20240401') NORTHVIEW_TOTAL_20240401

	--, (SELECT SUM(ESTTAX) FROM DBO.TAXDETAIL T      INNER JOIN PROPERTY P ON P.PROPERTYKEY=T.PROPERTYKEY AND P.TAXDISTRIC='03' WHERE TAXTYPE=8) CEDARCREEK_TOTAL
	--, (SELECT SUM(ESTTAX) FROM DBO.TAXDETAIL_LOG L  INNER JOIN PROPERTY P ON P.PROPERTYKEY=L.PROPERTYKEY AND P.TAXDISTRIC='03' WHERE TAXTYPE=8 AND CONVERT(DATE,LOG_DATE)='20240401') CEDARCREEK_TOTAL_20240401

	--, (SELECT SUM(ESTTAX) FROM DBO.TAXDETAIL T      INNER JOIN PROPERTY P ON P.PROPERTYKEY=T.PROPERTYKEY AND P.TAXDISTRIC='03' WHERE TAXTYPE=9) DEERFIELD_TOTAL
	--, (SELECT SUM(ESTTAX) FROM DBO.TAXDETAIL_LOG L  INNER JOIN PROPERTY P ON P.PROPERTYKEY=L.PROPERTYKEY AND P.TAXDISTRIC='03' WHERE TAXTYPE=9 AND CONVERT(DATE,LOG_DATE)='20240401') DEERFIELD_TOTAL_20240401

	--, (SELECT SUM(ESTTAX) FROM DBO.TAXDETAIL T      INNER JOIN PROPERTY P ON P.PROPERTYKEY=T.PROPERTYKEY AND P.TAXDISTRIC='03' WHERE TAXTYPE=10) ELIASSTATION_TOTAL
	--, (SELECT SUM(ESTTAX) FROM DBO.TAXDETAIL_LOG L  INNER JOIN PROPERTY P ON P.PROPERTYKEY=L.PROPERTYKEY AND P.TAXDISTRIC='03' WHERE TAXTYPE=10 AND CONVERT(DATE,LOG_DATE)='20240401') ELIASSTATION_TOTAL_20240401

	, (SELECT SUM(ESTTAX) FROM DBO.TAXDETAIL T      INNER JOIN PROPERTY P ON P.PROPERTYKEY=T.PROPERTYKEY AND P.TAXDISTRIC='03' WHERE TAXTYPE=11) FIRE_TOTAL
	, (SELECT SUM(ESTTAX) FROM DBO.TAXDETAIL_LOG L  INNER JOIN PROPERTY P ON P.PROPERTYKEY=L.PROPERTYKEY AND P.TAXDISTRIC='03' WHERE TAXTYPE=11 AND CONVERT(DATE,LOG_DATE)='20240411') FIRE_TOTAL_20240401

	--, (SELECT SUM(ESTTAX) FROM DBO.TAXDETAIL T      INNER JOIN PROPERTY P ON P.PROPERTYKEY=T.PROPERTYKEY AND P.TAXDISTRIC='03' WHERE TAXTYPE=12) OAKGROVE_TOTAL
	--, (SELECT SUM(ESTTAX) FROM DBO.TAXDETAIL_LOG L  INNER JOIN PROPERTY P ON P.PROPERTYKEY=L.PROPERTYKEY AND P.TAXDISTRIC='03' WHERE TAXTYPE=12 AND CONVERT(DATE,LOG_DATE)='20240401') OAKGROVE_TOTAL_20240401

	FROM DEFAULTS


