On-demand training: More Gems from the SQL Prompt Treasure Chest. Watch now.

INTO keyword not aligning correctly

a.higginsa.higgins Posts: 78 Bronze 2
edited August 30, 2016 1:32PM in SQL Prompt
When I start with the following code:
;WITH a AS
(
	SELECT
		1 AS x
	   ,2 AS y
)
SELECT * INTO #tmp FROM a

and apply formatting:
;WITH a AS
(
	SELECT
		1 AS x
	   ,2 AS y
)
SELECT
	a.x
   ,a.y INTO #tmp
FROM a

The "INTO #tmp" value is left hanging out after the last column, instead of being aligned with the SELECT and FROM

Expected result:
;WITH a AS
(
	SELECT
		1 AS x
	   ,2 AS y
)
SELECT
	a.x
   ,a.y 
INTO #tmp
FROM a

Comments

Sign In or Register to comment.