DSGVO Individuelle Kundenstammdaten exportieren

SELECT [Firma] = Company
      ,[Vorname] = FirstName
      ,[Nachname] = LastName
      ,[Adresse] = Address
      ,[Adresse 2] = Address2
      ,[Ort] = City
      ,[Land] = State
      ,[Postleitzahl] = ZIP
      ,[Liefer-Adresse] = ShipAddress
      ,[Liefer-Adresse 2] = ShipAddress2
      ,[Liefer-Ort] = ShipCity
      ,[Liefer-Postleitzahl] = ShipZIP
      ,[Telefon] = Phone
      ,[Telefon 2] = Phone2
      ,[E-Mail] = EMail
      ,[Geburtsdatum] = Birthdate
      ,[USt-IdNr.] = TaxID
      ,[Kundennummer] = AcctNo
      ,[Geschlecht] = case when Male = 1 then 'Männlich' else 'Weiblich' end
      ,[Gutschein Guthaben] = GiftBalance
      ,[Kunden Guthaben] = InStoreBalance
  FROM Customers
  WHERE AcctNo = <<Kundennummer oder Email>>
  or EMail = <<Kundennummer oder Email>>

Feedback and Knowledge Base