| | 1 | == Klienci dodani do bazy Truck_Expo po rozjechaniu wersji == |
| | 2 | {{{ |
| | 3 | SELECT * FROM Klienci |
| | 4 | WHERE CustomerID > 56710 |
| | 5 | ORDER BY CustomerID |
| | 6 | }}} |
| | 7 | |
| | 8 | == Klienci zdublowani po rozjechaniu wersji - porównuje miasto i nazwę po usunięciu spacji z przodu i z tyłu == |
| | 9 | {{{ |
| | 10 | SELECT |
| | 11 | Expo.CustomerID AS ExpoCustomerId, |
| | 12 | Baza.CustomerID, |
| | 13 | Expo.FirstName AS ExpoName, |
| | 14 | Baza.FirstName, |
| | 15 | Expo.City AS ExpoCity, |
| | 16 | Baza.City, |
| | 17 | Expo.data AS ExpoData, |
| | 18 | Baza.Data |
| | 19 | FROM Klienci Expo, BAZA_REKLAM.dbo.Klienci Baza |
| | 20 | WHERE |
| | 21 | --KE.data>='2008-03-10' |
| | 22 | Expo.CustomerID > 56710 |
| | 23 | AND RTRIM(LTRIM(LOWER(Expo.FirstName))) = RTRIM(LTRIM(LOWER(Baza.FirstName))) |
| | 24 | AND RTRIM(LTRIM(LOWER(Expo.City))) = RTRIM(LTRIM(LOWER(Baza.City))) |
| | 25 | ORDER BY Expo.CustomerID |
| | 26 | }}} |
