How is SQL Prompt helping your team? Share your experience.

$SELECTEDTEXT$ only expands once[email protected] Posts: 17 Bronze 2
edited August 25, 2015 10:38AM in SQL Prompt

setup a new snippet


when it expands the $SELECTEDTEXT$ only expands the second time it appears

Example result

sum ( $SELECTEDTEXT$ ) as tot_Current_db


  • Aaron LAaron L Posts: 596 New member
    Thanks for your post,

    The current implementation of $SELECTEDTEXT$ only expands once per a line, I think your snippet is a good example of why we would want to expand it more than this though! I'll have a look into removing this restriction and should have a new build for you later today.

  • Aaron LAaron L Posts: 596 New member
    We've just released a new build of Prompt ( which should allow you to use multiple $SELECTEDTEXT$ placeholders on a single line. You can download the latest build from our website or through the check for updates dialog inside Prompt. Please let me know if this works as you'd expect.

  • I've tried it and it now works as I had anticipated.

    Thanks for you quick response
Sign In or Register to comment.