declare @xml XML,@str varchar(max)
select			@str    = '<DATA>'
select top 1000 @str=@str+'<FLIGHT ID="1"><ROUTE NAPR="a"/><ROUTE NAPR="b"/></FLIGHT>' from sysobjects
set				@str=@str+'</DATA>'
set @xml=@str

SELECT
	ID =					nullif(c.value('@ID', 'INT' ),''),  
	ROUTE1 =				nullif(c.value('(ROUTE[1]/@NAPR)', 'varchar(50)' ),'')
	--,ROUTE2 =				nullif(c.value('(ROUTE[2]/@NAPR)', 'varchar(50)' ),'') 			
FROM @xml.nodes('/DATA/FLIGHT') t(c)

SELECT
	ID =					nullif(t.c.value('@ID', 'INT' ),''),  
	ROUTE1 =				nullif(a.n.value('@NAPR', 'varchar(50)' ),'')
	,ROUTE2 =				nullif(b.n.value('@NAPR', 'varchar(50)' ),'') 			
FROM @xml.nodes('/DATA/FLIGHT') t(c) cross apply
t.c.nodes('ROUTE[1]') a(n) cross apply
t.c.nodes('ROUTE[2]') b(n);