create table #emp (id int, name varchar(64), xml_data xml)

insert into #temp values

(1, 'one', '<data><info x="42" y="99">vignesh</info></data>'),

(2, 'two', '<data><info x="57" y="72">ram</info></data>'),

(3, 'three', '<data><info x="36" y="81">karthik</info></data>'),

(4, 'four', ...