Query a web service from SQL Server via CLR  

Posted by ReelTym

Full Article