======Count of Referrals by Primary Provider and Referral Source, for Intake Date Range======

Back to [[QueryDirectory Query Directory]]

//
Show number of referrals by referral source, sorted by provider, for a specified intake date range.
//
This query illustrates the use of an IF...ELSE...ENDIF expression in the SELECT list.

%%(sql)
SELECT
COALESCE(c.provcode,'No Pri Prov') AS "Primary Provider",
IF a.refsrcnum IS NULL
THEN 'No Ref'
ELSE TRIM(b.Refname + ' '+b.firstname)
ENDIF AS "Source Name",
COALESCE(b.reftype,'') AS "Ref Type",
COUNT(*) AS "Referrals"
FROM
patients a
LEFT OUTER JOIN refsrcs b ON a.refsrcnum = b.refsrcnum
LEFT OUTER JOIN providers c ON a.providernum = c.providernum
WHERE
a.intakedate BETWEEN '2000-01-01' AND '2008-08-20'
AND a.licnum = 101
GROUP BY "Primary Provider","Source Name", "Ref Type"
ORDER BY "Primary Provider","Source Name"
%%


----
CategoryQueries