What are the challenges you face when working across database platforms? Take the survey

SQL Stops correcting / working when I have a pivot.

CrispinProctorCrispinProctor Posts: 6
edited July 5, 2010 8:07AM in SQL Prompt Previous Versions
Hi Folks,

My sql prompt seems to stop working when I have a pivot in my code.
Another "odd" thing that happens is scrolling with the arrow keys is slow, as is typing. Holding down shift and using the arrow keys makes the cursor stumble across without highlighting the code. When you stop, it seems to catchup and highlight everything.

Snippets also stop working.

If I remove the pivot, it's all good again. Code is not really large, it's only 68 lines long. Without pivot, I have had a couple thousand and it's fine.

Anyone else have this?



  • Options
    Anu DAnu D Posts: 876 Silver 3
    Thanks for your feedback, and sorry you found this issue.

    I have reproduced the symptoms you reported and it seems that the presence of PIVOT or UNPIVOT will stop SQL Prompt working as you described.

    I have logged this as a bug with SQL Prompt, and it will hopefully be fixed in a future release.

    For your reference the bug tracking code for the issue is SP-2885.

    The only workaround I can really offer for the time being, is to comment out the words PIVOT or UNPIVOT, as this seems to kick SQL Prompt into life again.

    Thanks for taking the time to let us know about this.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    Thanks for the reply. I'll wait for an update.
Sign In or Register to comment.