Re: Export from one DB table into another DB table based on ID number
- From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 08 Jan 2009 23:39:32 +0100
On Thu, 8 Jan 2009 05:08:01 -0800, Transam388 wrote:
OK, I got an answer before but not exactly clear to me so trying again.(...)
How is this done? This will be an overwrite of the data in the second table
and not an addition. Again, have used Query Analyzer some but claim to be no
pro...obviously. This is also a fairly critical set of DB so I will back up
prior to doing this. Help greatly appreciated!!!!!!!!!!!!!
Hi Transam388,
I'm sorry to say this, but your description gives me some vague idea of
what you want, but not specific enough. Please post the following:
* The exact structure of the tables, posted as CREATE TABLE statements.
Make sure to include all indexes, constraints, and properties. You may
omit irrelevant columns, though.
* A few rows of well-chosen test data to illustrate the problem and all
possible relevant permutations. Please post them as INSERT statements so
that we can simply copy and paste the code in your post to create a copy
of your situation with all the test data on my computer. (If the photo
column is of the "image" datatype, then please replace it with the
"text" datatype and use a small description in the test data; images
don't post too well in newsgroups).
* The expected results, based on the test data you provided. If you post
these in a tabular format, then make sure to use a fixed-width font when
preparing your posts and use spaces, not tabs, to tabulate the data.
Otherwise, there's no way for others to see the data as neatly lined up
as you do.
See www.aspfaq.com/5006 for more details.
--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
.
- References:
- Export from one DB table into another DB table based on ID number
- From: Transam388
- Export from one DB table into another DB table based on ID number
- Prev by Date: Export from one DB table into another DB table based on ID number
- Next by Date: How to pick highest number
- Previous by thread: Export from one DB table into another DB table based on ID number
- Next by thread: How to pick highest number
- Index(es):
Relevant Pages
|
