Incorrect syntax error near '.'. in SQL server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Incorrect syntax error near '.'. in SQL server

Author

Topic

lalves
Starting Member

1 Post

Posted - 2014-04-28 : 13:33:18

SELECT
CASE WHEN TableWDM.ADRESSE_EMAIL IS NOT NULL
THEN TableWDM.ADRESSE_EMAIL
WHEN TableWDM.ADRESSE_EMAIL IS NULL
THEN dig.EMAIL END AS EMAIL,
...
TableWDM.Expr3,TableWDM.EMAIL_NUMERO_CLIENT_VAD,TableWDM.EMAIL_NUMERO_CLIENT_PRL, TableWDM.ADRESSE_EMAIL,

I am getting Incorrect syntax error near '.'. in SQL server. I am not able to find out my mistake. Please guide me.
Je rencontre un message d'erreur " Incorrect syntax error near'.'. " dans sql server. Je ne trouve pas à quoi est dû cette erreur. Quelqu'un pourrait il m'aider svp?

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-04-28 : 13:41:52

Since we can't see your entire query, it's hard to say which '.' SQL means. However, it looks like your CASE statement is missing an END keyword. Start by fixing that.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources