One needs to use the square brackets [ ] in this case (one of the few cases when there is no escape).

So the incorrect syntax SERVER.DOMAIN.DATABASE.SCHEMA.TABLE must become

[SERVER].[DATABASE].[SCHEMA].

e.g.

SELECT TOP 1...

Because your source XML file is sequential (you 've got key-value pairs) you need to peek ahead to compose a single row in the destination XML file based on two...

Hello, just wanted to add one more tool to the belt (besides, it was notably absent):

SQL Everywhere - a free SQL Server IDE (Integrated Development Environment) which supports all versions...