View difference between Paste ID: j0Y1Bra1 and ct0mBVcn

 -- Dear Redgate.  SQL Prompt owns for the most part, but the autoformatting options are kind of weak.
 -- Here's the way I like to format my code.
-
+
 if @dateOnly is not null
-if @dateOnly is not null begin
+begin
-    select
+	select
-        staffId,
+		staffId, staffName, a,
-        staffName,
+		day(@dateOnly)
-        a,
+	from dbo.personnel
-        day(@dateOnly)
+		inner join
-    from dbo.personnel
+		(	select fulladdresswithlongname
-        inner join (
+			from b
-            select fulladdresswithlongname from b
+		) ab on personnel.a = ab.a
-        ) ab on personnel.a = ab.a
+	where
-    where
+		len(empType) = 0
-        len(empType) = 0
+		and empType in
-        and empType in (
+		(	'a', 'b', 'd', 'g', 'i', 'k', 'p', 'q', 'r', 's',
-            'a', 'b', 'd', 'g', 'i', 'k', 'p', 'q', 'r', 's',
+			't', 'u', 'v', 'w', 'x', 'y', 'z', 'A', 'D', 'F',
-            't', 'u', 'v', 'w', 'x', 'y', 'z', 'A', 'D', 'F',
+			'I', 'K', 'M', 'N', 'O', 'Q', 'X', 'Z'
-            'I', 'K', 'M', 'N', 'O', 'Q', 'X', 'Z'
+		)
-        )
+