[KLUG Members] Re: Database import help

[John Holland]

Not dumb at all, just learning a new subject.  I don't have a
recommendation for a basic SQL book.  O'Reilly
(http://databases.oreilly.com/) has some interesting books.

By crosswalk, I mean that you need a way to match student IDs to 
the internal linking numbers.  Do you have another table that has
both student IDs and internal linking numbers?

On Thu, Feb 27, 2003 at 02:31:52PM -0800, Andy wrote:
> Ok.. not to sound to dumb .. ( though I will profess
> my ignorance when it comes to SQL statements) 
> 
> I understand the Joining of tables.. but I have no
> reference to the crosswalking of data you are speaking
> of.. I have about 3 different references (though most
> are on administering the database and only 1 is on
> actual query structure) So I assume you are saying
> that I could setup a Query that will Insert all the
> data from Temptable to Live table except for the field
> that needs to change? Or would I do the insert and
> then have to run an Update on those rows that I just
> inserted to do correct that field? 
> 
> Could you point me to a good Transact-SQL reference
> that may help me in my search (I would rather learn
> than ask for an out right answer). 

-- 
John Holland 
john@zoner.org
http://www.zoner.org