[progress Communities] [progress Openedge Abl] Forum Post: Sql View Creation: Many Rows To...

[Randy Kight]

Was hoping someone could assist me with an example of how I might create a sql view, where some columns within that view contain comma delimited values from 1 to many other records within the database...denormalizing many records into one if you will. Example: patient_id, policy_number, diagnosis_codes where the view's diagnosis_codes column would be a distinct list of values found from our patient_policy.diagnosis_code column for all the patient_policy table records for that patient for a particular policy. If anyone has experience with this, sincerely appreciate the time in response.

Continue reading...