Re: SELECT statement efficiency question

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Sun, 8 Apr 2007 00:30:14 -0500
Message-ID: <hd_Rh.1812$w41.1081@newssvr19.news.prodigy.net>

"Mladen Gogala" <mgogala.SPAM_ME.NOT_at_verizon.net> wrote in message news:pan.2007.04.08.03.54.32_at_verizon.net...
> On Sat, 07 Apr 2007 22:52:08 -0500, Dereck L. Dietz wrote:
>
> What the closer look at the query reveals is a missing object. I don't
> know many people named "DATA" (even the Startrek NG character is a machine
> which doesn't run Windows) or "CORRECTION" and the columns like the first
> and last name are usually reserved for humans. Your data structure is
> trying to make distinctly inhuman entities look human. What you're
> probably looking for is another column.

This is a data warehouse load. The input source has some rows with "DATA" and "CORRECTION" in the name fields which indicate there needs to be a data correction and also that those rows are NOT to be loaded into the tables.

Thanks. Received on Sun Apr 08 2007 - 00:30:14 CDT