Incorrect syntax near ')'. SQL Server

Question

I have this SQL Server query that causes this error

Incorrect syntax near ')'

in my Windows Forms application written in C#.

I think this can cause in different way and I'm stuck at it finding where that syntax error is. It seems the error is around:

datetime2) >= CAST("12/30/1996 12:00:00 AM" as datetime2) and upper(status

Here's my full query

select * 
from 
    (select 
         PMSEQ, SWERK, EQUNR,
         MPTYPE, DATE, TIME,
         RECDC, IDIFF, READR,
         IIND, QMART 
     from 
         P_PM_TBLIF240 
     where 
         cast(concat(concat(date, ' '), time) as datetime2) >= cast('12/30/1996 12:00:00 AM' as datetime2) 
         and upper(status) = 'ACTIVE') a  
where 
    PMSEQ not in ()

Hope someone help to get out here

Thank you in advance

Please do not add unnecessary tags. This doesn't have anything to do with C#, let alone a WinForms user interface. — ProgrammingLlama
– ProgrammingLlama, Commented Jan 8, 2020 at 2:55

zip · Accepted Answer · 2020-01-08 02:42:53Z

2

The problem is that not in () is empty.

Run the scipt below:

select * from (select PMSEQ,SWERK,EQUNR,MPTYPE,DATE,TIME,RECDC,IDIFF,READR,IIND,QMART from P_PM_TBLIF240 where CAST(concat(concat(date,' '), time) as datetime2) >= CAST('12/30/1996 12:00:00 AM' as datetime2) and upper(status) = 'ACTIVE') a  where PMSEQ not in ('1')

Because I dont have the data, I am going with the guess that PMSEQ is text. Let me know

answered Jan 8, 2020 at 2:42

zip

4,0612 gold badges13 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Berzerk25 Over a year ago

i think that you can put an empty in not in() base on w3school sql syntax tutorial

Ken White Over a year ago

@Berzerk25: I think your understanding is wrong. An empty set makes no sense in SQL. Quoting w3school as an authority is useless. Try the SQL Server Books on Line (Google it), which is the official documentation for SQL Server.

Berzerk25 Over a year ago

yes your answer is correct,. thank you for the help

Collectives™ on Stack Overflow

Incorrect syntax near ')'. SQL Server

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related