[SQL] Need some help with crafting a query to do major update

To all, This is part of a data warehouse. Made the mistake of using a natural key in one of the fact tables. :-( The f_test_pageviews is a simple testing table while I work this out. The real table has an identical schema. I have built a mapping table, d_user, to allow the replacement of

Re: [SQL] Need some help with crafting a query to do major update

On Wed, 18 Feb 2004, Sean Shanny wrote: To all, This is part of a data warehouse. Made the mistake of using a natural key in one of the fact tables. :-( The f_test_pageviews is a simple testing table while I work this out. The real table has an identical schema. I have built a