| | 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 | }}} |
| | 27 | |
| | 28 | == Kontakty Truck_Expo po rozjechaniu wersji == |
| | 29 | {{{ |
| | 30 | SELECT * FROM Kontakty |
| | 31 | WHERE Kontakty.Data > '2008-03-11' |
| | 32 | }}} |
| | 33 | |
| | 34 | == Reklamy Truck_Expo == |
| | 35 | {{{ |
| | 36 | SELECT CustomerID, * FROM Reklama WHERE [TYTUŁ]='EXPO' AND [ID REKLAMY] LIKE 'X%' |
| | 37 | }}} |
| | 38 | |
| | 39 | == Reklamy Truck_Expo zatwierdzone do druku == |
| | 40 | {{{ |
| | 41 | SELECT CustomerID, * FROM Reklama |
| | 42 | WHERE [ID REKLAMY] LIKE 'X%' AND [TYTUŁ]='EXPO' AND [zatwierdzono do druku]=1 |
| | 43 | }}} |
| | 44 | |
| | 45 | == Faktury wystawione dla Truck_Expo == |
| | 46 | {{{ |
| | 47 | SELECT ID_Nabywcy AS CustomerID, * |
| | 48 | FROM FAKTURY |
| | 49 | WHERE ID_FAKTURY IN |
| | 50 | ( |
| | 51 | SELECT ID_FAKTURY FROM Reklama WHERE [ID REKLAMY] LIKE 'X%' AND [TYTUŁ]='EXPO' AND [zatwierdzono do druku]=1 |
| | 52 | ) |
| | 53 | ORDER BY ID_FAKTURY, CustomerID |
| | 54 | }}} |
