Re: SQL - Combine multiple records to give 1 record

premgoel_at_gmail.com wrote:
> This is basically to track the period for which the patient was taking
> a drug. The patients fills a prescription before the previous one
> finishes. So the patient is on the same drug withourt interruption.

Patients often miss days, often stop taking meds, and often overlap prescriptions.

It may be your business rules ... but it isn't reality.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)