Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 01 May 2009 @ 14:08:56 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Update / case statement
From:   Anomy Anom

<-- Anonymously Posted: Friday, May 01, 2009 11:32 -->

Hi Glenn,

Thank you for your input.

I actually managed to fix the problem right after posting my message.

It had to do with the simple fact that the single quotes I used in the sql were not recognized due to the fact I copied them (and the whole conditional clause)from a word document and pasted into my program!

Also, you are totally correct about the embedded cases clause... As soon as I fixed the problem with the quotations

I realized I should move the first case statement into a where clause the way you did.

Thanks again!

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023