Error When Running The Code: Incorrect syntax near the keyword 'CASE'

[tksnota]

Hi,

I need help on these codes because I'm getting the error as shown from the subject.  FYI. gbkmut.bdr_hfl are numeric values

CASE WHEN gbkmut.transtype IN ('N','C','P','F')
AND gbkmut.transsubtype NOT IN ('R','S')
AND gbkmut.bdr_hfl >= 0
OR gbkmut.transsubtype IN ('R','S')
AND gbkmut.bdr_hfl < 0
THEN gbkmut.bdr_hfl
ELSE NULL
END AS Debit,

CASE WHEN gbkmut.transtype IN ('N','C','P','F')
AND gbkmut.transsubtype NOT IN ('R','S')
AND gbkmut.bdr_hfl >= 0
OR gbkmut.transsubtype IN ('R','S')
AND gbkmut.bdr_hfl < 0
THEN NULL
ELSE -gbkmut.bdr_hfl
END AS Credit

[Smalfly]

Hi @tksnota ,

for your printscreen I don't see the whole SQL query but it needs to be a query that runs on its own in your SQL evironment. So it will be something like select columnA, columnB from TableX.

If your query looks correct, try running it in your SQL environment. That might give you a more meaningful error.

Good luck!

[tksnota]

I still got the same error...

SELECT gbkmut.reknr, gbkmut.bdr_hfl
CASE WHEN gbkmut.transtype IN ('N','C','P','F')
AND gbkmut.transsubtype NOT IN ('R','S')
AND gbkmut.bdr_hfl >= 0
OR gbkmut.transsubtype IN ('R','S')
AND gbkmut.bdr_hfl < 0
THEN gbkmut.bdr_hfl
ELSE NULL
END AS Debit,

SELECT gbkmut.reknr, gbkmut.bdr_hfl
CASE WHEN gbkmut.transtype IN ('N','C','P','F')
AND gbkmut.transsubtype NOT IN ('R','S')
AND gbkmut.bdr_hfl >= 0
OR gbkmut.transsubtype IN ('R','S')
AND gbkmut.bdr_hfl < 0
THEN NULL
ELSE -gbkmut.bdr_hfl
END AS Credit

[Smalfly]

Try this:

SELECT gbkmut.reknr, gbkmut.bdr_hfl,
CASE WHEN gbkmut.transtype IN ('N','C','P','F') AND gbkmut.transsubtype NOT IN ('R','S') AND gbkmut.bdr_hfl >= 0 OR gbkmut.transsubtype IN ('R','S') AND gbkmut.bdr_hfl < 0
THEN gbkmut.bdr_hfl
ELSE NULL END AS Debit,
CASE WHEN gbkmut.transtype IN ('N','C','P','F') AND gbkmut.transsubtype NOT IN ('R','S') AND gbkmut.bdr_hfl >= 0 OR gbkmut.transsubtype IN ('R','S') AND gbkmut.bdr_hfl < 0
THEN NULL ELSE -gbkmut.bdr_hfl END AS Credit
FROM gbkmut

What I did:

* I added a comma behind gbkmut.bdr_hfl

* I removed your second select statement

* I added a from statement in which I assumed gbkmut is your table name

[tksnota]

Hi,

It worked!

Is it possible to get the whole fields of gbkmut instead of the couple?

I used SELECT * but got the same error as shown

[Smalfly · Accepted solution]

Good to hear that your problem is solved!

Just add a comma behind the * and the quety will give you all the columns in the table.

[tksnota]

"601"{[Schema="dbo",Item="gbkmut"]}[Data] - Forgot to add this one