It looks like SQL Prompt is tripping up on this bit of code:
WITH (FORCESEEK (1 (CntyCd, CdVal)))
As a work around you can delete that bit of SQL, format everything and then reinsert it.
We are planning on improving some of the prompt parser over the next few weeks so i'll make sure adding support for this is on our list.
gvarol@corelogic.com
Posts: 90 Bronze 3
Comments
WITH (FORCESEEK (1 (CntyCd, CdVal)))
As a work around you can delete that bit of SQL, format everything and then reinsert it.
We are planning on improving some of the prompt parser over the next few weeks so i'll make sure adding support for this is on our list.
Thanks,
Aaron.