;with xmlnamespaces (default 'MySchema', 'http://www.w3.org/2001/XMLSchema' as xsd)
select
	T.C.value('local-name(.)', 'nvarchar(max)') as Field_Name,
	case 
		when Types.Type = 'float' then T.C.value('data(.)', 'float')
	end as FloatValue,
	case 
		when Types.Type = 'datetime' then T.C.value('data(.)', 'datetime')
	end as DateTimeValue
from @xml.nodes('/Data') as A(B)
	outer apply A.B.nodes('@*') as T(C)
join 
(select 
	Sch.Attr.value('data(@name)', 'nvarchar(max)') as Name,
	Sch.Attr.value('substring(data(@type), 10)', 'nvarchar(max)') as Type
from 
	@xml.nodes('*//xsd:attribute') as Sch(Attr) 
) as Types on T.C.value('local-name(.)', 'nvarchar(max)') = Types.Name