Databases Reference
In-Depth Information
Figure 9-67
16. To build the remote partition, click the New Partition link. On the first
page, click the checkbox next to dbo.FactInternetSales under Avail-
able Tables, and then click Next.
17. On the Restrict Rows page of the wizard; enable "Specify a query to
restrict rows."
The partition wizard creates a relational select query up to the
WHERE clause. At the end of the WHERE clause, type in "Order-
DateKey<=184" as shown in Figure 9-68 and click Next.
 
 
Search WWH ::




Custom Search