Call a webservice from TSQL (Stored Procedure) using MSXML By Vishal
http://www.vishalseth.com/post/2009/12/22/Call-a-webservice-from-TSQL-(Stored-Procedure)-using-MSXML.aspx
/****** Object: StoredProcedure [dbo].[SPP_SAP_HTTPRequest] Script Date: 21/11/2016 10:06:17 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc [dbo].[SPP_SAP_HTTPRequest]
@URI varchar(4000) = '',
@methodName varchar(