RE: CASE statement in query produces error - "invalid identifier"
From: William Threlfall <William.Threlfall_at_albertahealthservices.ca>
Date: Tue, 11 Feb 2014 13:48:22 -0700
Message-ID: <36800EC4761690448F1B444A1AEF44BB13E89148_at_EXMBXC5.crha.bewell.ca>
Kim - you are awesome! Thank you very much for taking the time to provide all the detailed explanations and examples! The method you described and explained not only resolved that one example (AST closest to 1 month post-transplant) but I used the same or similar techniques to resolve about 20 other similar types of lab result extracts as well.
This message and any attached documents are only for the use of the intended recipient(s), are confidential and may contain privileged information. Any unauthorized review, use, retransmission, or other disclosure is strictly prohibited. If you have received this message in error, please notify the sender immediately, and then delete the original message. Thank you.
Date: Tue, 11 Feb 2014 13:48:22 -0700
Message-ID: <36800EC4761690448F1B444A1AEF44BB13E89148_at_EXMBXC5.crha.bewell.ca>
Kim - you are awesome! Thank you very much for taking the time to provide all the detailed explanations and examples! The method you described and explained not only resolved that one example (AST closest to 1 month post-transplant) but I used the same or similar techniques to resolve about 20 other similar types of lab result extracts as well.
Cheers, - Bill.
This message and any attached documents are only for the use of the intended recipient(s), are confidential and may contain privileged information. Any unauthorized review, use, retransmission, or other disclosure is strictly prohibited. If you have received this message in error, please notify the sender immediately, and then delete the original message. Thank you.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 11 2014 - 21:48:22 CET