Containers are an incredibly powerful technology that can provide you and/or your engineering team with huge productivity gains. Using containers, you can deploy, back up, replicate, and move apps and their dependencies quickly and easily.
/*** EDD Listing by Patient by Date by Provider **/ SET NOCOUNT ON SELECT DISTINCT dbo.FormatName('', pp.First, pp.Middle, pp.Last, pp.Suffix) AS PatientName, pp.PatientId, pp.Phone1, CONVERT(DATETIME, o.OBSVALUE, 102) AS EDCDate, p.ListName AS Provider, pp.Birthdate, DATEDIFF(d, pp.Birthdate, GETDATE()) / 365.25 AS Age, SUBSTRING(o.OBSVALUE, 1, 2) AS EDCMonth, SUBSTRING(o.OBSVALUE, 4, 2) AS EDCDay, RIGHT(o.OBSVALUE, 4) AS EDCYear FROM dbo.OBS AS o INNER JOIN dbo.OBSHEAD AS oh ON o.HDID = oh.HDID INNER JOIN dbo.PatientProfile AS pp ON o.PID = pp.PId INNER JOIN dbo.DoctorFacility AS p ON pp.DoctorId = p.DoctorFacilityId WHERE ( o.HDID = 2683 ) AND o.XID = 1000000000000000000 AND CONVERT(DATETIME, o.OBSVALUE) >= ISNULL('03/01/2011', '1/1/1900') AND CONVERT(DATETIME, o.OBSVALUE) < DATEADD(day, 1, ISNULL('03/31/2011', '1/1/3000')) AND --Filter on doctor ( ( NULL IS NOT NULL AND pp.DoctorID IN ( NULL ) ) OR ( NULL IS NULL ) )
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.