You are right, and that is why I wanted to avoid doing it this way.. I first did it like this- a user can click on a device name and...

There is no relation, idea is to display the recent data first row.. So if there are two type 1 and type 2 measurements at 10:00 and 9:00 each then...

Hi Jared,

There is a single observations table with these columns I listed here and some more columns. The database is connected to a WS.. the web service accepts HL7 data...

Ahh yes.. Thank you very much

Hi Cadavre

Thanks for this, it seems like I am going somewhere now with this way.. and yes it is not simple to use pivot with this.. btw I think you...

Hi,

Thanks for your reply. Yes I am familiar with Joins, I tried many ways, one of them is:

With MeasurementType1 As

(Select * from Observations where measurementtype=1 and date=.........)

measurementtype2 AS

(

...........)

...............

then joining each...