Results 1 to 2 of 2

Thread: How to table drive a case statement?

  1. #1
    Join Date
    Aug 2010
    Posts
    1

    How to table drive a case statement?

    Is there any way to table drive a case statement that has varying criteria and "IN" comparisons like this. I don't think there is but thought I'd seek other advice. I'm on SQL Server 2000, but soon moving to 2008.

    WHEN F1='TKAAA.....'
    AND F2='213000B'
    AND F3='0317120'
    AND F4 IN ('4997') THEN 'Value1'
    WHEN F1 IN ('F3C6BB','F3C6BC','F3C6BD')
    AND F3='209000C'
    AND F4 IN ('2105','2106') THEN 'Value2'

    Thanks!

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •