Re: Query to split one table into 2

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: David Portas (REMOVE_BEFORE_REPLYING_dportas_at_acm.org)
Date: 08/11/04

Next message: Kalvin: "Re: From clause with parenthese - Posted once but server error"
Previous message: Scott Simons: "Re: simple query locking too much data"
In reply to: David Portas: "Re: Query to split one table into 2"
Next in thread: M K: "Re: Query to split one table into 2"
Messages sorted by: [ date ] [ thread ]

Date: Wed, 11 Aug 2004 14:38:00 +0100

Oops. That last insert should have read:

INSERT INTO ProductPriceCodes (productid, gpcode1, gpcode2, gpcode3)
SELECT DISTINCT P.productid, O.code1, O.code2, O.code3
  FROM OldData AS O
  JOIN Products AS P
   ON O.customer = P.photographerid
    AND O.sort = P.sort
    AND O.program = P.programname
    AND O.package = P.packagename

-- 
David Portas
SQL Server MVP
--

Next message: Kalvin: "Re: From clause with parenthese - Posted once but server error"
Previous message: Scott Simons: "Re: simple query locking too much data"
In reply to: David Portas: "Re: Query to split one table into 2"
Next in thread: M K: "Re: Query to split one table into 2"
Messages sorted by: [ date ] [ thread ]