adventure works dw.dsv

来自「< SQL Server2005程序设计>」· DSV 代码 · 共 666 行 · 第 1/5 页

                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="NumberCarsOwned" msprop:FriendlyName="NumberCarsOwned" msprop:DbColumnName="NumberCarsOwned" msprop:design-time-name="e9494803-0118-4174-acb8-ff42fca4ce23" type="xs:unsignedByte" minOccurs="0" />
                  <xs:element name="IsCarOwner" msprop:FriendlyName="IsCarOwner" msprop:DbColumnName="IsCarOwner" msprop:design-time-name="6c249312-4299-478c-a06b-57ba00d7940e" type="xs:int" minOccurs="0" />
                  <xs:element name="NumberCarsOwnedGroup" msprop:FriendlyName="NumberCarsOwnedGroup" msprop:DbColumnName="NumberCarsOwnedGroup" msprop:design-time-name="5066cc62-5fcd-4c81-a205-99d7e60f87d2" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="7" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="AddressLine1" msprop:FriendlyName="AddressLine1" msprop:DbColumnName="AddressLine1" msprop:design-time-name="dabe821c-ec65-4404-bb17-af5d0226d956" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="120" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="AddressLine2" msprop:FriendlyName="AddressLine2" msprop:DbColumnName="AddressLine2" msprop:design-time-name="ecc92ace-d54e-4b9c-8ca7-46efd99f8b5f" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="120" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="Phone" msprop:FriendlyName="Phone" msprop:DbColumnName="Phone" msprop:design-time-name="e937a5d2-e10f-4e6c-96d6-e53d9ae85b44" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="20" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="DateFirstPurchase" msprop:FriendlyName="DateFirstPurchase" msprop:DbColumnName="DateFirstPurchase" msprop:design-time-name="2e9e4590-9b74-4d1c-a4c9-4f9502bb72d0" type="xs:dateTime" minOccurs="0" />
                  <xs:element name="CommuteDistance" msprop:FriendlyName="CommuteDistance" msprop:DbColumnName="CommuteDistance" msprop:design-time-name="3f67c988-b6a7-4a5c-9266-6978d3187baf" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="15" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="IsNorthAmerica" msprop:FriendlyName="IsNorthAmerica" msprop:DbColumnName="IsNorthAmerica" msprop:design-time-name="42728b9b-6224-40df-8c4e-f5bd071b81bb" type="xs:int" minOccurs="0" />
                  <xs:element name="IsPacific" msprop:FriendlyName="IsPacific" msprop:DbColumnName="IsPacific" msprop:design-time-name="321873b1-f8cf-4dc2-adf4-faa309e6db85" type="xs:int" minOccurs="0" />
                  <xs:element name="IsEurope" msprop:FriendlyName="IsEurope" msprop:DbColumnName="IsEurope" msprop:design-time-name="fcdb39ab-9846-4cfb-bde7-6a323af6f46f" type="xs:int" minOccurs="0" />
                  <xs:element name="AgeUnder30" msprop:FriendlyName="AgeUnder30" msprop:DbColumnName="AgeUnder30" msprop:design-time-name="f3e3e90f-f65f-478a-b673-9a93a60d4cd3" type="xs:int" minOccurs="0" />
                  <xs:element name="Age30_35" msprop:FriendlyName="Age30_35" msprop:DbColumnName="Age30_35" msprop:design-time-name="77f2bf0f-c310-42e0-8d8b-469aee775c96" type="xs:int" minOccurs="0" />
                  <xs:element name="Age36_45" msprop:FriendlyName="Age36_45" msprop:DbColumnName="Age36_45" msprop:design-time-name="19a4e49a-5625-4ba6-8653-f57ef62ede5d" type="xs:int" minOccurs="0" />
                  <xs:element name="Age46_55" msprop:FriendlyName="Age46_55" msprop:DbColumnName="Age46_55" msprop:design-time-name="6693243a-662c-4245-bd02-a91a54621fe8" type="xs:int" minOccurs="0" />
                  <xs:element name="AgeOver55" msprop:FriendlyName="AgeOver55" msprop:DbColumnName="AgeOver55" msprop:design-time-name="9213d143-94a6-4e20-9f6f-9dc43438f428" type="xs:int" minOccurs="0" />
                  <xs:element name="AgeGroup" msprop:FriendlyName="AgeGroup" msprop:DbColumnName="AgeGroup" msprop:design-time-name="7d6c8330-887f-49b4-94f5-dcf928b21a96" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="9" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="AgeSquared" msprop:FriendlyName="AgeSquared" msprop:DbColumnName="AgeSquared" msprop:design-time-name="3609e022-6dcf-4cb2-8432-3bcf9caafc71" type="xs:int" minOccurs="0" />
                  <xs:element name="NumOrders" msprop:FriendlyName="NumOrders" msprop:DbColumnName="NumOrders" msprop:design-time-name="aba7facb-593b-42d9-8114-36e222ad2eee" type="xs:int" minOccurs="0" />
                  <xs:element name="IsOneTimeCustomer" msprop:FriendlyName="IsOneTimeCustomer" msprop:DbColumnName="IsOneTimeCustomer" msprop:design-time-name="135150e1-cada-4052-935c-ae82670435bd" type="xs:int" minOccurs="0" />
                  <xs:element name="Recency" msprop:FriendlyName="Recency" msprop:DbColumnName="Recency" msprop:design-time-name="59eccc30-961c-4651-8f80-af9d3dc6b1c0" type="xs:int" minOccurs="0" />
                  <xs:element name="IsWithin12Months" msprop:FriendlyName="IsWithin12Months" msprop:DbColumnName="IsWithin12Months" msprop:design-time-name="233b6815-c1bd-45ca-8b95-0058a4f23006" type="xs:int" minOccurs="0" />
                  <xs:element name="Is13_18Months" msprop:FriendlyName="Is13_18Months" msprop:DbColumnName="Is13_18Months" msprop:design-time-name="45085889-be24-44c0-acd3-dc3a70b46fa8" type="xs:int" minOccurs="0" />
                  <xs:element name="Is19_24Months" msprop:FriendlyName="Is19_24Months" msprop:DbColumnName="Is19_24Months" msprop:design-time-name="dc2d6713-9bac-4137-8ccd-f93d5aa9820c" type="xs:int" minOccurs="0" />
                  <xs:element name="IsMoreThan24Months" msprop:FriendlyName="IsMoreThan24Months" msprop:DbColumnName="IsMoreThan24Months" msprop:design-time-name="0efa3548-ab67-4410-8e4d-61c3e5f29f4a" type="xs:int" minOccurs="0" />
                  <xs:element name="RecencyGroup" msprop:FriendlyName="RecencyGroup" msprop:DbColumnName="RecencyGroup" msprop:design-time-name="812b958b-351f-4fe5-9626-f4a35063f84f" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="19" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="NumberOfProducts" msprop:FriendlyName="NumberOfProducts" msprop:DbColumnName="NumberOfProducts" msprop:design-time-name="69b5c563-5497-4337-a5fd-19d3b5c4d4f7" type="xs:int" minOccurs="0" />
                  <xs:element name="NumProdSquared" msprop:FriendlyName="NumProdSquared" msprop:DbColumnName="NumProdSquared" msprop:design-time-name="3cdffc37-9afd-4487-ae58-26ea12980578" type="xs:int" minOccurs="0" />
                  <xs:element name="NumProdGroup" msprop:FriendlyName="NumProdGroup" msprop:DbColumnName="NumProdGroup" msprop:design-time-name="b871ff55-6d47-4aba-b0e0-fb6be456fa70" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="2" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="IsFewerThan5" msprop:FriendlyName="IsFewerThan5" msprop:DbColumnName="IsFewerThan5" msprop:design-time-name="9d98f766-d7eb-441e-8c56-4deb05fde2b6" type="xs:int" minOccurs="0" />
                  <xs:element name="NumProdHiLo" msprop:FriendlyName="NumProdHiLo" msprop:DbColumnName="NumProdHiLo" msprop:design-time-name="7d7c0957-c27d-49c2-b257-8fbd5e68491d" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="11" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="NumProdLast12" msprop:FriendlyName="NumProdLast12" msprop:DbColumnName="NumProdLast12" msprop:design-time-name="19b0e995-28a7-4dfc-9cf1-ad5e07229990" type="xs:int" minOccurs="0" />
                  <xs:element name="Tenure" msprop:FriendlyName="Tenure" msprop:DbColumnName="Tenure" msprop:design-time-name="93e19115-da42-4e19-b1dd-cac97a159d61" type="xs:int" minOccurs="0" />
                  <xs:element name="IsNewCustomer" msprop:FriendlyName="IsNewCustomer" msprop:DbColumnName="IsNewCustomer" msprop:design-time-name="e72adbdd-a317-4cee-aea6-5fb95328ab6c" type="xs:int" minOccurs="0" />
                  <xs:element name="NewCustomerGroup" msprop:FriendlyName="NewCustomerGroup" msprop:DbColumnName="NewCustomerGroup" msprop:design-time-name="714c530d-28c0-4ec3-a226-5c8381efbd42" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="11" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="NumBikes" msprop:FriendlyName="NumBikes" msprop:DbColumnName="NumBikes" msprop:design-time-name="414c6464-e19c-4969-8c0f-d0f76d7bade6" type="xs:int" minOccurs="0" />
                  <xs:element name="RevenueBikes" msprop:FriendlyName="RevenueBikes" msprop:DbColumnName="RevenueBikes" msprop:design-time-name="b59f39e2-85ce-4402-817f-1a19d7bd89e5" type="xs:decimal" minOccurs="0" />
                  <xs:element name="ProfitBikes" msprop:FriendlyName="ProfitBikes" msprop:DbColumnName="ProfitBikes" msprop:design-time-name="e7837904-3938-4acf-8050-c5b8a6850a45" type="xs:decimal" minOccurs="0" />
                  <xs:element name="NumComponents" msprop:FriendlyName="NumComponents" msprop:DbColumnName="NumComponents" msprop:design-time-name="0313c407-473a-450b-83bd-245328993577" type="xs:int" minOccurs="0" />
                  <xs:element name="RevenueComponents" msprop:FriendlyName="RevenueComponents" msprop:DbColumnName="RevenueComponents" msprop:design-time-name="0c0a2ff5-9239-4934-8f01-028416e64b4a" type="xs:decimal" minOccurs="0" />
                  <xs:element name="ProfitComponents" msprop:FriendlyName="ProfitComponents" msprop:DbColumnName="ProfitComponents" msprop:design-time-name="0130ea7c-b4fb-40ce-89fe-01b0ebda6e51" type="xs:decimal" minOccurs="0" />
                  <xs:element name="NumClothing" msprop:FriendlyName="NumClothing" msprop:DbColumnName="NumClothing" msprop:design-time-name="dee7f5f5-ceb8-42ee-84fa-be16d47346e5" type="xs:int" minOccurs="0" />
                  <xs:element name="RevenueClothing" msprop:FriendlyName="RevenueClothing" msprop:DbColumnName="RevenueClothing" msprop:design-time-name="0dee53ff-2039-44ba-be37-9d5420fea57c" type="xs:decimal" minOccurs="0" />
                  <xs:element name="ProfitClothing" msprop:FriendlyName="ProfitClothing" msprop:DbColumnName="ProfitClothing" msprop:design-time-name="61e5c57e-d868-4ce2-884c-2032b133d236" type="xs:decimal" minOccurs="0" />
                  <xs:element name="NumAccessories" msprop:FriendlyName="NumAccessories" msprop:DbColumnName="NumAccessories" msprop:design-time-name="c1841347-5282-4bb1-9761-720788cb864b" type="xs:int" minOccurs="0" />
                  <xs:element name="RevenueAccessories" msprop:FriendlyName="RevenueAccessories" msprop:DbColumnName="RevenueAccessories" msprop:design-time-name="22036f23-9227-4574-88b9-77b7bc5e6b06" type="xs:decimal" minOccurs="0" />
                  <xs:element name="ProfitAccessories" msprop:FriendlyName="ProfitAccessories" msprop:DbColumnName="ProfitAccessories" msprop:design-time-name="2e548b8b-00aa-437b-9746-83f0f43676f2" type="xs:decimal" minOccurs="0" />
                  <xs:element name="IsBikeBuyer" msprop:FriendlyName="IsBikeBuyer" msprop:DbColumnName="IsBikeBuyer" msprop:design-time-name="0fce4ae8-8054-49e4-a40b-7b2f173b1473" type="xs:int" minOccurs="0" />
                  <xs:element name="IsComponentBuyer" msprop:FriendlyName="IsComponentBuyer" msprop:DbColumnName="IsComponentBuyer" msprop:design-time-name="ded60c6f-58da-4065-98c2-41154d7051d0" type="xs:int" minOccurs="0" />
                  <xs:element name="IsClothingBuyer" msprop:FriendlyName="IsClothingBuyer" msprop:DbColumnName="IsClothingBuyer" msprop:design-time-name="e97ec9bf-d747-4f38-b1e5-64f17deb7afe" type="xs:int" minOccurs="0" />
                  <xs:element name="IsAccessoryBuyer" msprop:FriendlyName="IsAccessoryBuyer" msprop:DbColumnName="IsAccessoryBuyer" msprop:design-time-name="d90d4545-e295-4cf8-ba44-cf0f17960ab5" type="xs:int" minOccurs="0" />
                  <xs:element name="BikeBuyer" msprop:FriendlyName="BikeBuyer" msprop:DbColumnName="BikeBuyer" msprop:design-time-name="b273e09b-64ad-475b-b715-786e9b3058c9" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="1" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="ComponentBuyer" msprop:FriendlyName="ComponentBuyer" msprop:DbColumnName="ComponentBuyer" msprop:design-time-name="facdba9e-1b3f-4354-beb1-e45188851687" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="1" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="ClothingBuyer" msprop:FriendlyName="ClothingBuyer" msprop:DbColumnName="ClothingBuyer" msprop:design-time-name="e43e259a-a203-482d-a4f1-31494582bb81" minOccurs="0">
                    <xs:simpleType>
                      <xs:re