Update Advanced SQL Puzzles Solutions.sql

smpetersgithub · web-flow · commit f4b46914c6b3 · 2024-07-19T12:40:39.000-05:00
diff --git a/Advanced SQL Puzzles/Advanced SQL Puzzles Solutions.sql b/Advanced SQL Puzzles/Advanced SQL Puzzles Solutions.sql
@@ -4071,11 +4071,11 @@ GO
 WITH cte_BatchLines_Go AS
 (
 SELECT  *
-FROM    ##BatchLines
+FROM    #BatchLines
 WHERE   Syntax = 'GO'
 )
 SELECT  a.Batch, a.BatchStart, MIN(b.Line) AS MinLine
-FROM    ##BatchStarts a LEFT JOIN
+FROM    #BatchStarts a LEFT JOIN
         cte_BatchLines_Go b ON b.Line >= a.BatchStart AND a.Batch = b.Batch
 GROUP BY a.Batch, a.BatchStart;
 

Original file line number	Diff line number	Diff line change
`@@ -4071,11 +4071,11 @@ GO`
`4071`	`4071`	`WITH cte_BatchLines_Go AS`
`4072`	`4072`	`(`
`4073`	`4073`	`SELECT *`
`4074`		`-FROM ##BatchLines`
	`4074`	`+FROM #BatchLines`
`4075`	`4075`	`WHERE Syntax = 'GO'`
`4076`	`4076`	`)`
`4077`	`4077`	`SELECT a.Batch, a.BatchStart, MIN(b.Line) AS MinLine`
`4078`		`-FROM ##BatchStarts a LEFT JOIN`
	`4078`	`+FROM #BatchStarts a LEFT JOIN`
`4079`	`4079`	`cte_BatchLines_Go b ON b.Line >= a.BatchStart AND a.Batch = b.Batch`
`4080`	`4080`	`GROUP BY a.Batch, a.BatchStart;`
`4081`	`4081`