$CURRENT_SEL$ macro seems to be broken

I have the following macro, triggered with Alt+0:

	Code:
	SELECT sq\| FROM ( $CURRENT_SEL$ ) AS sq

Now, when I try to apply that to a selected query, let's say this one:

	Code:
	SELECT COUNT(1) AS c FROM sys.databases AS d

the expected result would be

	Code:
	SELECT sq\|\| <-cursor blinking here FROM ( SELECT COUNT(1) AS c FROM sys.databases AS d ) AS sq

But instead of that I get this:

	Code:
	SELECT SELECT COUNT(1) AS c FROM sys.databases AS d \|<-cursor blinking here sq SELECT COUNT(1) AS c FROM sys.databases AS d FROM SELECT COUNT(1) AS c FROM sys.databases AS d ( SELECT COUNT(1) AS c FROM sys.databases AS d SELECT COUNT(1) AS c FROM sys.databases AS d SELECT COUNT(1) AS c FROM sys.databases AS d ) AS sq

Having selected multiple lines yields a total mess:
Source:

	Code:
	SELECT COUNT(1) AS c FROM sys.databases AS d

Result:

	Code:
	SELECT SELECT sq SELECT FROM SELECT ( SELECT SELECT COUNT(1) AS c FROM sys.databases AS d SELECT ) AS sq

SA version 6.2.77

I failed to reproduce this issue. Which target editor and version are you using?

Can you reproduce the issue when using right-click menu -> SQL Assistant -> Code Snippets -> [Select the same snippet from Code Snippets menu]?

Target editor and environment info

	Quote:
	Microsoft SQL Server Management Studio 10.50.2500.0 Microsoft Analysis Services Client Tools 10.50.2500.0 Microsoft Data Access Components (MDAC) 6.1.7601.17514 Microsoft MSXML 3.0 5.0 6.0 Microsoft Internet Explorer 9.0.8112.16421 Microsoft .NET Framework 2.0.50727.5456 Operating System 6.1.7601

It works properly both from context and main menus, triggering it with Alt + number causes problems.

EDIT: I made a few tests and this is what I got:
Snippet:

	Code:
	-- 1 -- 2 -- 3 -- 4 -- 5 $CURRENT_SEL$ -- 6 -- 7 -- 8 -- 9 -- a

Original query:

	Code:
	SELECT COUNT(1) AS c FROM sys.databases AS d

After transformation:

	Code:
	-- 1 SELECT -- 2 SELECT -- 3 SELECT -- 4 SELECT -- 5 SELECT SELECT COUNT(1) AS c FROM sys.databases AS d SELECT -- 6 SELECT -- 7 SELECT -- 8 SELECT -- 9 SELECT -- a

Other snippets having a single line statement containing $CURRENT_SEL$ operate normally. Multiline snippets are broken.
Any ideas?

That seems to happen only when using Alt+number hot keys. I wonder if such hot keys conflict with hot keys for setting and manipulating code bookmarks.

PS. I tried your latest code snippet version and it's working well for me when I'm using menus.

	SysOp wrote:
	That seems to happen only when using Alt+number hot keys. I wonder if such hot keys conflict with hot keys for setting and manipulating code bookmarks.

I removed hotkeys for code bookmarks but that did not help.

	SysOp wrote:
	PS. I tried your latest code snippet version and it's working well for me when I'm using menus.

Invoking the snippet from menus works fine but the previous versions did not have this issue. Three of my Alt+Num snippets utilize $CURRENT_SEL$ macro and I used them pretty frequently in the past. All of them are broken now.

Any news on this?

Yes. Fixed. Please wait 1 more day :-)

Certainly :) Lots of good news today :D