Create Procedure [dbo].[sendNotifOCR_{1}] 
@Pid as int, @unid as int, @uid as int as 
      Declare @URL varchar(1000) 
      Declare @Object as Int;
set
   @URL = '{0}/modules/concierge/notifyPackageOCR.aspx?packageID=' + cast(@Pid as varchar(4)) + '&userID=' + cast(@unid as varchar(10)) + '&unitID=' + cast(@uid as varchar(8)) Exec sp_OACreate 'MSXML2.XMLHTTP', @Object OUT;
Exec sp_OAMethod @Object, 'open', NULL, 'get', @URL, 'false' Exec sp_OAMethod @Object, 'send'