[KLUG Members] Re: Database import help

[Andy]

yes I have a table with both.. the main student table
has  both in it. The table that this information goes
to is already created and has data in it. 

I still haev to move some data around because I just
found out that the test data is in the wrong format
too.. So I may be just retyping the whole thing..
thanks for the help though.. I do have SQL Server 2000
Unleashed that I have just started to read.
--- John Holland <john@zoner.org> wrote:
> 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
> _______________________________________________
> Members mailing list
> Members@kalamazoolinux.org
>



__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/