Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
COURSE of the MONTH
8 days, 1 hour left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
T-SQL, SQL Server Help
Posted on 2010-09-11
Hi all,
Bit of SQL help here, i'm really stuck been working on this for a couple hours. No idea why i'm getting an error whenever I run this SQL query, using a text driver through an ODBC connection to query a csv file...
Can anyone see anything wrong with my sql?
select payee.*,
payee.AHIRDA+'/'+payee.AHI
CASE ATRMDA
WHEN 0 THEN '31/12/2999'
ELSE payee.ATRMDA+'/'+payee.ATR
END AS Termination_Date
from
ptaagr0999.csv payee
Any help much appreciated.
I keep getting hte following error:
Syntax error(Missing operator) in query expression
'CASE ATRMDA
WHEN 0 THEN '31/12/2999'
ELSE payee.ATRMDA+'/'+payee.ATR
END'
Thanks a lot..
Bit of SQL help here, i'm really stuck been working on this for a couple hours. No idea why i'm getting an error whenever I run this SQL query, using a text driver through an ODBC connection to query a csv file...
Can anyone see anything wrong with my sql?
select payee.*,
payee.AHIRDA+'/'+payee.AHI
CASE ATRMDA
WHEN 0 THEN '31/12/2999'
ELSE payee.ATRMDA+'/'+payee.ATR
END AS Termination_Date
from
ptaagr0999.csv payee
Any help much appreciated.
I keep getting hte following error:
Syntax error(Missing operator) in query expression
'CASE ATRMDA
WHEN 0 THEN '31/12/2999'
ELSE payee.ATRMDA+'/'+payee.ATR
END'
Thanks a lot..
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3 Comments
Active 2 days ago
>using a text driver through an ODBC connection to query a csv file...you cannot do that, the text driver does not support all the MS SQL syntax.you have to load the text file with a plain SELECT * into a local table, and then query from there.this technique is called "staging" ...
Which data type does ATRMDA have?
If it is date and you want to check for NULL you need to use
CASE ATRMDA
WHEN NULL THEN '31/12/2999'
ELSE payee.ATRMDA+'/'+payee.ATR
END AS Termination_Date
If it is date and you want to check for NULL you need to use
CASE ATRMDA
WHEN NULL THEN '31/12/2999'
ELSE payee.ATRMDA+'/'+payee.ATR
END AS Termination_Date
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder.
But why not let Windows retr…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro:
Us…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses
Course of the Month8 days, 1 hour left to enroll
765 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.