Notifications
Clear all
Topic starter
I have the following query
select pp.PatientProfileId AS MRN, DD.SDID, pp.Last AS LastName, pp.First AS FirstName,
CONVERT(varchar(10), pp.Birthdate, 101) AS DOB,
substring(DATA,patindex('%assessment/plan%',DATA),2000), dbo.Convert_ID_to_date(clinicaldate)
as ClincalDate
FROM
DOCDATA dd inner join DOCUMENT do on dd.SDID = do.SDID
inner join PatientProfile pp on do.PID = pp.PId
WHERE DATA LIKE '%assessment/plan%'
and pstatus = 'A'
and dbo.Convert_ID_to_date(clinicaldate) > '1/1/2012'
When I excute it, the DATA portion is not complete to the end of the informatio I see via the UI.
I have checked for mulitple linked rows and found none for my test.
What could I be missing?
Thanks.
John
Posted : March 3, 2015 2:16 pm
Reach me at [email protected] and I will attempt to work through the problem with you.
Posted : March 4, 2015 5:49 am
DocData is separated into multiple rows, so you have to use COALESCE to bring them all together
Posted : March 4, 2015 5:50 am
Does this represent what you are trying to do?
Posted : March 4, 2015 6:06 am
