Re: Partitioned view on two columns

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Lubor Kollar (lubork_at_online.microsft.com)
Date: 11/24/04

Next message: Yalaman: "RE: Cannot use parameter in 'from' section"
Previous message: Paul: "Field mapping on Importing"
In reply to: Pederb: "Partitioned view on two columns"
Next in thread: Peder Bacher: "Re: Partitioned view on two columns"
Reply: Peder Bacher: "Re: Partitioned view on two columns"
Messages sorted by: [ date ] [ thread ]

Date: Wed, 24 Nov 2004 08:54:40 -0800

Peder, I assume that you are trying to create Updateable Partitioned View.
If that is the case, the constraint must be on a single column only.
Unfortunately this cannot be a computed column so you have to deal with
mapping the pairs (([intSite],[datDate]) to a single integer in your
application and make it a new column in your tables.

Lubor Kollar, Microsoft

Next message: Yalaman: "RE: Cannot use parameter in 'from' section"
Previous message: Paul: "Field mapping on Importing"
In reply to: Pederb: "Partitioned view on two columns"
Next in thread: Peder Bacher: "Re: Partitioned view on two columns"
Reply: Peder Bacher: "Re: Partitioned view on two columns"
Messages sorted by: [ date ] [ thread ]