I'm trying to use the
WITH clause and
IF statement, but it does not seem to work and I cannot find any reason why it would not. Syntax should be correct and still it is complaining about the syntax.
The error I receive is "Incorrect syntax near ';'. I have tried removing
; characters, but then it says "Incorrect syntax near the keyword 'IF'.
Is it even possible to use the WITH and IF syntax like this? The query does work without the
IF statements (with only one of the select queries).
With measurements as ( (SELECT * from measurement_database1) UNION ALL (SELECT * from measurement_database2) UNION ALL (SELECT * from measurement_database3) ); IF @device= 'en1' AND @other_parameter= 'yes' ( select * from measurements where device like 'en1' and op like 'yes' ); IF @device= 'en2' AND @other_parameter= 'no' ( select * from measurements where device like 'en2' and op like 'no' ); IF @device= 'en3' AND @other_parameter= 'yes' ( select * from measurements where device like 'en3' and op like 'yes' );
I'm running Microsoft SQL Server 2012 11.0.6607.3.