Help - Query Oracle to Sql Server

SELECT xmlagg(xmlelement(e,pcr.ds_resposta).extract('//text()') order by pcr.nr_seq_resposta).getClobVal() as ds_resposta, 
  pcr.ds_resposta,
		       pcr.id_quest_resposta, 
		       tqr.ds_resposta ds_comentario 
		  FROM tbg_quest_resposta tqr right outer join prt_check_resposta pcr on  tqr.id_quest_resposta = pcr.id_quest_resposta