FR - UE : RGPD Exporter les données de base individuelles des clients
,[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>>