Incorrect syntax near the keyword 'WITH'

Just want to share info.

I'm was creating SQL Query to launch from Navision with ADO. The Query was some thing like:

WITH CONTR AS 
( SELECT CT.[No_],CT.[Customer Name],CT.[Address],
ROW_NUMBER() OVER (ORDER BY [No_]) AS RowNumber 
FROM dbo.Contracts CT )
SELECT * FROM CONTR WHERE RowNumber BETWEEN 1 AND 10

In SQL Management Studio this query executed without problems, but when launching from Navision I got error Message:
"The call to member Execute failed. Microsoft OLE DB Provider for SQL Server returned the following message:
Incorrect syntax near the keyword 'WITH'."

The solution was simple, but I doubt I would find it without help of Google All what was needed was adding semicolon before WITH. This code works fine:

;WITH CONTR AS 
( SELECT CT.[No_],CT.[Customer Name],CT.[Address],
ROW_NUMBER() OVER (ORDER BY [No_]) AS RowNumber 
FROM dbo.Contracts CT )
SELECT * FROM CONTR WHERE RowNumber BETWEEN 1 AND 10

May be someone can explain the solution...