declare
	@strSQL				nvarchar(1024)
	,@cmd				varchar(1024)

select @strSQL = ''
	+ 'select ''<?xml version=""1.0"" encoding=""utf-8""?>'' + ( '
	+ 'select CURRENT_TIMESTAMP [@date], ( '
	+ 'select ( '
		+ 'select * '
		+ 'from ( '
			+ 'select 	ENT_ART, REST_QTY '
			+ 'from ' + @DBName + '..ADV_CRM_EXPORT_ENTITIES '
		+ ') AS v(articul, quantity) '
		+ 'for xml path(''item''), TYPE '
	+ ') '
	+ 'for xml path(''items''), TYPE '
	+ ') '
	+ 'for xml path(''shop'') '
	+ ') '

select @cmd = 'bcp "'
	+ @strSQL
	+ '" '
    + 'queryout "' + @OutputFileName + '" -w -C1251 -r -T -x';

exec xp_cmdshell @cmd