Viewing 2 posts - 1 through 2 (of 2 total)
select (CONVERT(VARCHAR(10), VISIT_DATE, 101)), count(Distinct PATIENT_ID) from XXOH_AMT group by VISIT_DATE
December 28, 2011 at 4:31 am
#1426021
This will help you,
update A SET A.DID='X'
from
LOCN A
join
ACS B
On
A.LID = B.LID
JOIN
ACO C
ON
B.UID = C.UID
where
C.TYPE = 'd'
December 28, 2011 at 3:52 am
#1426007