BEGIN/*multilne
comment*/
/*comment1*/
/*comment2*/
IF 1 = 1 PRINT 1
/*comment3*/
/*comment4*/
IF 1 = 1 PRINT 2
/*comment5*/
/*comment6*/
END

BEGIN
  /*comment1*/
  /*comment2*/
  IF 1 = 1 PRINT 1
  /*comment3*/
  /*comment4*/
  IF 1 = 1 PRINT 2
  /*comment5*/
  /*comment6*/
END

-- Comment
IF  (@VariableI  = 'Value')
AND (@VariableII = 'Value2') BEGIN
	-- Select comment
	SELECT	TOP(10)
		tb .Field1
	,	tb2.Field2
	,	CASE WHEN tb.Field3 = 'Value3' THEN 'Y' ELSE 'N' END	AS Field3	-- Inline comment
	,	CASE	WHEN tb.Field3 = 'Value3'
			THEN 'Y'
			ELSE 'N'
			END						AS Field3b
	,	CASE	WHEN tb.Field4 = 0
			 AND tb.Field3 = 'Value1'	THEN 'A'
			WHEN tb.Field3 = 'Value2'	THEN 'B'
							ELSE 'C'
			END						AS Field3с
	FROM		dbo.TableI	tb
		JOIN	dbo.Table2	tb2 ON tb2.IdentityField = tb .IdentityField
	LEFT	JOIN	dbo.Table3	tb3 ON tb3.IdentityField = tb2.IdentityField
	WHERE	tb.Field4 IN ('AAA','BBB')	-- Inline comment
	AND	tb.Field5 != 0
	GROUP BY tb.Field1
	,	tb2.Field2
	,	tb .Field3
	ORDER BY 1
END

SELECT	X.Col1
,	X.Col2
,	Col3	= 1 + 2
,	Col4	= X.Col1 + X.Col2

select 
	x.value('@lagerId', 'int'),
	x.value('@quantity', 'numeric(18,3)')
from data.nodes('ROOT/data/row') as T(x)