I would go with the second approach. I don't want to add a new column to my
table, when we decide to measure BP at a new interval.
Vyas, MVP (SQL Server)
What hardware is your SQL Server running on?
"topdog" <com> wrote in message
I have a database that has repeated measures. PatientID, BPat5mins,
I am telling my co-worker that instead the table design should be
PatientID, BP, TimeInterval
My co-worker is telling me that the first way allows for easier grouping and
aggregates. What do you guys think.