Your code makes perfect sense..but when I run it on my data.. as ...

SELECT *

FROM (SELECT Grade,Term,SchoolAttn,SCHLYear,Status,SchoolNum,Stulink

      FROM SASI.ACHS5031

      WHERE ((SCHLYEAR = '2002')

        AND (GRADE = '09')

        AND...

Your question quite rightly outlined the poor syntax of my question...I've re-written it.... and include it here..

sorry for the me induced confusion...

I have a query I've been working on (below) which I want...

It is the date of last inventory...so I'm guessing it's just a plain old date.

You didn't mis-read.. .I didn't adequately communicate my information.  The table needs to be re-indexed ..(rather than simply output) so users will see the information from the table in the...

Well now ... sorry ... as it turns out.. I now find out from the owner of the data that it is possibe for there to be a duplicate date...

When I ran this, I got this result ...

(497 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

Server: Msg 2601, Level 14, State 3, Line 39

Cannot insert duplicate key row in object 'ASAH5032'...

The problem with this proc is that there cannot be duplicate sequence numbers (I just discovered) for a single stulink, so when I try to run this, I get a...

That seems  a very elegant way to do this. thank you...

In addition to the records I'll be inserting with this proc ... there are already existing records put in manually by...

Sorry for the delay on this.... got sent out on a "road trip".   I've found another glitch in this project... the records when appended to the target table must have...

Ahhh .. got it...

So .. here are the two DDL's for the tables I'm working with

First, ACHS

REATE TABLE [SASI].[ACHS5031] (

 [STATUS] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

 [SCHOOLNUM] [varchar]...

Ahhh.. that makes sense...  

Is there a procedure for creating the DDL for my tables?

D -  Data

D - Dictionary

L -  ????????

Hmmm.. I tried your code.. which ended up looking like this.. due to the need to populate non-null fields in ASAH5031...

Insert into sasi.asah5031(status,Schoolnum,stulink,FromDate,ToDate,schlattnum,City,State,GradeLevel,

byautoproc,[sequence])

select distinct SASI.ACHS5031.Status,SASI.ACHS5031.Schoolnum,SASI.ACHS5031.stulink, '09/01/02', '06/01/03','Schoolname', 'MyTown', 'MyState', '09','Y','1'

from...

The servers are remote on a T1 WAN.   No VPN involved.  By Update, I mean overwrite the contents of the derived table with the most recent data... replace.. not append.. because we...

Thanks.. there are more colums, but none with unique features.   Your second query works, but won't fill my requirement due to their being duplicate entries in the table for instances...