You will need to use a subquery something like:
(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
Read this if you want to know how to get a correct reply for your question:
.: Wrox Technical Editor :.
Wrox Books 24 x 7