INSERT INTO [WFServices].[dbo].[kh_Kontrahent] ([ID_kh_Baza]
      ,[id]
      ,[skrot]
      ,[nazwa]
      ,[kodKraju]
      ,[statusUE]
      ,[Miejscowosc]
      ,[ulica]
      ,[numerDomu]
      ,[numerMieszk]
      ,[kod]
      ,[Poczta]
      ,[Telefon1]
      ,[Telefon2]
      ,[Telefax]
      ,[Telex]
      ,[email]
      ,[PlatnikVAT]
      ,[nazwisko]
      ,[imie]
      ,[nip]
      ,[pesel]
      ,[Regon]
      ,[www]
      ,[pozycja]
      ,[aktywny]
      ,[Uwagi]
      ,[StatusPrzetworzenia]
      ,[DataPrzetworzenia]
      ,[Blad])
	  select 2 as [ID_kh_Baza],null as [id],isnull(c.ShortName,'') as [skrot], isnull(c.Name,'') as [nazwa],'' as [kodKraju], 0 as [statusUE], isnull(AddressCity,''), isnull(AddressStreet,'')
	  , isnull(cast(AddressNb1 as nvarchar),''), isnull(cast(AddressNb2 as nvarchar),'')
	  ,isnull( AddressPostCode,''), '', isnull(AddressTelephone,''), '','','',isnull(AddressEmail,''),1,null,null
	  ,isnull(cast(c.TaxNumber as nvarchar),''),'','',isnull(AddressWebPage,''), null, 1 , '', null,null,null
	  from WF_HEG.dbo.Contractor c inner join WF_HEG.dbo.ContractorExt cx on c.oid=cx.oid
where c.oid = @oid