upsert.sql

USE [DMP_Dev]
GO

DECLARE @RC int
DECLARE @io_CompanyId int
DECLARE @i_CompanyIdentifier varchar(36) = '1234567890'
DECLARE @i_CompanyStatusId smallint = 1
DECLARE @i_CompanyName varchar(100) = 'Funk Inc.'
DECLARE @i_WebSiteURL varchar(100)
DECLARE @i_CompanyRemovalReasonId smallint
DECLARE @i_CompanyAddressId int
DECLARE @i_Address1 varchar(50) = '123 Prospect St'
DECLARE @i_Address2 varchar(50)
DECLARE @i_Address3 varchar(50)
DECLARE @i_City varchar(35) = 'Endicott'
DECLARE @i_State char(2) = 'NY'
DECLARE @i_Zip char(5) = '12345'
DECLARE @i_Zip4 char(4)
DECLARE @i_PostalCode varchar(15)
DECLARE @i_AddressCountryCode char(3) = 'USA'
DECLARE @i_BusinessCompanyPhoneId int
DECLARE @i_BusinessPhoneNumber varchar(20) = '716-456-4545'
DECLARE @i_BusinessPhoneCountryCode char(3) = 'USA'
DECLARE @i_FaxCompanyPhoneId int
DECLARE @i_FaxNumber varchar(20)
DECLARE @i_MarketingCompanyEmailId int
DECLARE @i_MarketingEmailAddress varchar(254)
DECLARE @i_LoginName varchar(128)
DECLARE @o_ReturnMessage varchar(max)

-- TODO: Set parameter values here.

EXECUTE @RC = [dbo].[DATA_MAINTENANCE@UpsertCompanyChannelInfo] 
   @io_CompanyId OUTPUT
  ,@i_CompanyIdentifier
  ,@i_CompanyStatusId
  ,@i_CompanyName
  ,@i_WebSiteURL
  ,@i_CompanyRemovalReasonId
  ,@i_CompanyAddressId
  ,@i_Address1
  ,@i_Address2
  ,@i_Address3
  ,@i_City
  ,@i_State
  ,@i_Zip
  ,@i_Zip4
  ,@i_PostalCode
  ,@i_AddressCountryCode
  ,@i_BusinessCompanyPhoneId
  ,@i_BusinessPhoneNumber
  ,@i_BusinessPhoneCountryCode
  ,@i_FaxCompanyPhoneId
  ,@i_FaxNumber
  ,@i_MarketingCompanyEmailId
  ,@i_MarketingEmailAddress
  ,@i_LoginName
  ,@o_ReturnMessage OUTPUT
select top 5 companyexternalidentifier, companyId, companyname from company order by companyId desc