Results 1 to 2 of 2

Thread: solving query

  1. #1
    Join Date
    Apr 2009
    Posts
    7

    solving query

    having this query which was working fine
    but started giving syntax error
    need to solve this query to get the result


    SELECT a.NAME,(case when (a.XLNAME IS null) OR (a.XLNAME = ' '))
    a.NAME else a.XLNAME end) as E_COL ,[order],width,b.column_name,
    b.data_type FROM (SELECT * FROM XLS_XLS where status=1 and [order]<>0)
    as A Left Join
    (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='STUDENT')
    as B ON A.NAME=B.COLUMN_NAME ORDER BY A.[order]

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    For which rdbms? Can you post error message?

Posting Permissions

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