Parse xml at server

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic


   <Calendar CompactMode="1" Locale="1049">
  <CustomProperties>
    <CustomProperty Name="clientfk" Value="2" VariantType="2" />
    <CustomProperty Name="reporttext" Value="rrrrrrrrrr" VariantType="16396" />
  </CustomProperties>
</Calendar>

this is the result of the custom properties field in sql server but I am unable to get the info out of it any ideas for TSQL

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
graham@efmail.co.uk Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 25 February 2014 Status: Offline Points: 3	Post Options Post Reply Quote graham@efmail.co.uk Report Post Thanks(0) Quote Reply Topic: Parse xml at server Posted: 25 February 2014 at 2:29pm
	<Calendar CompactMode="1" Locale="1049"> <CustomProperties> <CustomProperty Name="clientfk" Value="2" VariantType="2" /> <CustomProperty Name="reporttext" Value="rrrrrrrrrr" VariantType="16396" /> </CustomProperties> </Calendar> this is the result of the custom properties field in sql server but I am unable to get the info out of it any ideas for TSQL

graham@efmail.co.uk Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 25 February 2014 Status: Offline Points: 3	Post Options Post Reply Quote graham@efmail.co.uk Report Post Thanks(0) Quote Reply Posted: 26 February 2014 at 12:34pm
	Don't worry I cracked it