For Query #194, TP Procs..., the date returns System.Byte[].
I tried changes per viewtopic.php?f=1&t=3149 but couldn't make it work. Could you share the best query for a proper result? Thank you.
/*TP Procs with date of treatment plan of patients with no scheduled appointment with date of TP > given date Like #50 with date limitation*/
SET @SinceDate='2011-11-01';
SELECT CONCAT(LName, ', ',FName, ' ', MiddleI) AS Patient,
pc.ProcCode AS 'Code', abbrdesc AS 'Description', ToothNum, DATE_FORMAT(pl.ProcDate,'%m-%d-%Y') AS 'Date',
ap.AptStatus, ProcFee
FROM patient
INNER JOIN procedurelog pl ON patient.PatNum=pl.PatNum
INNER JOIN procedurecode pc ON pl.CodeNum= pc.CodeNum
LEFT JOIN appointment ap ON pl.AptNum=ap.AptNum
WHERE (isnull(ap.aptnum) OR AptStatus=6 OR AptStatus=3) AND
pl.ProcDate >= @SinceDate
AND ProcStatus=1 AND PatStatus=0
ORDER BY aptstatus, patient.LName, patient.FName ASC;