User Profile

Collapse

Profile Sidebar

Collapse
tena
tena
Last Activity: Mar 9 '07, 05:31 PM
Joined: Jul 31 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • tena
    replied to CASE in a Select Problem
    in SQL Server
    OK-tried that and still get:


    Msg 156, Level 15, State 1, Line 4
    Incorrect syntax near the keyword 'is'.


    TIA~

    Tena
    See more | Go to post

      Leave a comment:

    • tena
      started a topic CASE in a Select Problem
      in SQL Server

      CASE in a Select Problem

      Hi,
      I am getting a syntax error when I run the following, can anyone take a look and provide feedback?

      TIA~

      Tena

      SELECT View_ACTIVE_IQ_ USERS.fo_studen t_id, View_ACTIVE_IQ_ USERS.user_pk1 AS ETUserID, 'Y' AS Active,
      View_ACTIVE_IQ_ USERS.first_nam e,View_ACTIVE_I Q_USERS.address 2,View_ACTIVE_I Q_USERS.address 1,
      Address = CASE View_ACTIVE_IQ_ USERS.address2...
      See more | Go to post
      No activity results to display
      Show More
      Working...