Hello all:

I would like to know if the the following info below can be done.
I am using SQL Server 2000 and I can only perform lookups.

Here is an example of current table data.

Date Time Procedure Result
-------------- ------- --------- ------
12-Jul-2007 10:00 HGB 10.5
12-Jul-2007 10:00 HCT 31.0
13-Jul-2007 11:00 HGB 11.0
13-Jul-2007 11:00 HCT 33.0


What I would like it to look like is:

Date Time HGB HCT
----------- ----- ----- -----
12-Jul-2007 10:00 10.5 31.0
13-Jul-2007 11:00 11.0 33.0


Thanks,
Tony

You will need to use a subquery something like:

select distinct
    t1.date,
    t1.timeRec,
    (SELECT result from <yourtablename> where date = t1.date and [procedure] = 'HGB') as HGB,
    (SELECT result from <yourtablename> where date = t1.date and [procedure] = 'HCT') as HCT
FROM <yourtablename> t1

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor :.
Wrox Books 24 x 7
================================================== =========

dparsons:

Thank you.. Worked perfectly.

glad it worked for you

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor :.
Wrox Books 24 x 7
================================================== =========