Hi RBS,

Looking at the fastest way to convert a field in a table and wonder if in general an update with a CASE WHEN construction or an update with a join to
a lookup table is faster.

Perhaps the alternative form of the CASE statement would be faster, but I don't know:

case ENTRY_TYPE
        when  9 then 'Issue
        when  2 then 'Note'
        when  1 then 'Encounter'
        when  8 then 'Authorisation'
        when 11 then 'Prescription'
        when  5 then 'Treatment'
        when  3 then 'Problem'
        when 13 then 'Discontinuation'
        when  6 then 'Reminder'
        when 14 then 'Adverse reaction'
        when -1 then 'Unknown'
        when  4 then 'Sub-problem'
        when  7 then 'Battery'
        when 10 then 'Return-Script'
        else ENTRY_TYPE
end

Tom


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to