case when function - SQL Server Forums

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

SQL Server 2000 Forums

SQL Server Development (2000)

case when function

Author

Topic

hubschrauber
Starting Member

16 Posts

Posted - 2005-11-16 : 07:48:02

My when function is not working, I get an error 170: incorrect syntax near '=', I hope someone can help me.

SELECT datepart(ww,getdate()) AS Expr1, datepart(yyyy,getdate()) AS Expr2, r_tbl_el_210_open_vorigeweek.transaction_id,
r_tbl_el_210_open_vorigeweek.switch_id, r_tbl_el_210_open_vorigeweek.ouderdom, r_tbl_el_210_open_vorigeweek.bakje,

([verwerking] = Case When [verwerking]='H' Then [verwerking]=true Else [verwerking]=false End) AS Handm
FROM (r_tbl_el_210_open RIGHT JOIN r_tbl_el_210_open_vorigeweek ON r_tbl_el_210_open.transaction_id = r_tbl_el_210_open_vorigeweek.transaction_id)
LEFT JOIN tbl_issues_all ON r_tbl_el_210_open_vorigeweek.bakje = tbl_issues_all.IssueID
WHERE (((r_tbl_el_210_open.transaction_id) Is Null))

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-11-16 : 07:52:02

Replace

([verwerking] = Case When [verwerking]='H' Then [verwerking]=true Else [verwerking]=false End) AS Handm

by

([verwerking] = Case When [verwerking]='H' Then 'true' Else 'false' End) AS Handm

Madhivanan

Failing to plan is Planning to fail

hubschrauber
Starting Member

16 Posts

Posted - 2005-11-16 : 08:03:14

It still doesn't work I get the same error again

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2005-11-16 : 08:11:23

Replace:
([verwerking] = Case When [verwerking]='H' Then [verwerking]=true Else [verwerking]=false End) AS Handm

with:
Case When [verwerking]='H' Then true Else false End AS Handm

Or with:
Case When [verwerking]='H' Then 'true' Else 'false' End AS Handm
if true and false are not column names

CODO ERGO SUM

mymatrix
Starting Member

24 Posts

Posted - 2005-11-17 : 00:53:05

Replace :
([verwerking] = Case When [verwerking]='H' Then [verwerking]=true Else [verwerking]=false End) AS Handm

with:

Case verwerking When 'H' Then 'True' Else 'False' End AS Handm

This may help You.. :)

thnks
Gaurav

Even my blood group says be -ve to all the negatives.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources