Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

Apply Casing Options error combining FOR SYSTEM_TIME with HAVING

I've been experiencing a recurring error with SQL Prompt and a specific query.  After trying to strip out all the bits and pieces, I've been able to isolate the behavior to a situation that has two queries, both of which contain FOR SYSTEM_TIME ALL specification and the HAVING clause.

If I take out either the HAVING or FOR SYSTEM_TIME ALL specification, formatting is able to successfully apply casing options.  But, if I leave the query as-is, formatting fails to apply casing options.

SELECT *
FROM TableA
    FOR SYSTEM_TIME ALL a
HAVING COUNT(*) >1

SELECT *
FROM TableB FOR SYSTEM_TIME ALL b
HAVING COUNT(*) >1

Tagged:

Answers

Sign In or Register to comment.