INSERT INTO wfservices.[dbo].[itg_kontrahenci]
           ([skrot]
           ,[nazwa]
           ,[nip]
           ,[Miejscowosc]
           ,[rejon]
           ,[ulica]
           ,[nrDomu]
           ,[nrMieszkania]
           ,[kodPocztowy]
           ,[Telefon1]
           ,[Telefon2]
           ,[Telefax]
           ,[Telex]
           ,[email]
           ,[www]
		   ,[IDWF]
		   ,[CompanyWF])
select left(ShortName,40), [Name], TaxNumber, AddressCity, null,AddressStreet, AddressNb1, AddressNb2, AddressPostCode
,addressmobile, AddressTelephone, null, null, AddressEmail, AddressWebPage, OID, Company
  from contractor where oid=@Oid

set @NewId = @@IDENTITY

set @Company_ITG=1

INSERT INTO wfservices.[dbo].[itg_ustaleniKontrahenci]
           ([id_firmy]
           ,[id_kontrahenta]
           ,[pozycja]
           ,[DodajLubZmodyfikuj]
           ,[DataPrzetwazania]
           ,[BladPrzetwazania])
select @Company_ITG, @NewId, null,1, null,null from contractor where oid=@Oid
end
end