HHA System Administration

SELECT * FROM #Request.prefix_db_agency#.Homework h, #Request.prefix_db_lookup#.Agency a Where h.Agency_ID = a.Agency_ID and a.Status = 'active' and h.DateCreated > '2012-12-31' ORDER BY h.Homework_ID DESC HHA System Administration Superadmin Home

Communication Log

Date	Agency	Employee	Regarding...
#DATEFORMAT(DateCreated,"mm/dd/yyyy")#	#Agency_Name#	#Employee#	#TheirNotes#