Hi,
I have two tables MEASUREMENTS AND PARAMETERS. I want to be able create a row in PARAMETERS from the data in MEASUREMENTS. The data in PARAMETERS is an average for each year. This is a 'BULK INSERT' type procedure.
For example:
MEASUREMENTS:
IDNO, MEASDATE, MEASTYPE, VALUE1, VALUE2, VALUE3, VALUE4
1, 1/2/2004, WT, 78
1, 1/12/2004, WT, 95
1, 1/12/2004, HT, 176
1, 1/2/2004, CHOL, 6.7, 1.5, 1.12, 4.2
1, 1/12/2004, CHOL, 4.1, 1.2, 1.13, 2.2
.
.
.
Creating:
PARAMETERS:
IDNO YEARAVERAGE HEIGHT WEIGHT TOTALCHOL TRI HDL LDL
1, 2004, 176, 86.5, 5.4, 1.35, 1.125, 3.2
.
.
.
In this example When MEASTYPE = CHOL VALUE1 maps to TOTALCHOL, VALUE2 maps to TRI, VALUE3 maps to HDL & Value4 maps to LDL.
I have 10 diferent MEASTYPE CODES each with a variable number of values.
Can this be achieved with T-SQL via a stored procedure or should I just use a script to acieve the right outcome?
Any opinions or thoughts would be most welcome.