|
Home > Archive > MS SQL Server New Users > February 2006 > need to combine tables
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
need to combine tables
|
|
| Jennifer Mar 2006-01-27, 9:23 am |
| hi,
I recently migrated a database from an old server to a new one. however, one
of the tables didn't copy over all of the data, specifically one column. I
have the missing data on the old server but am unable to restore from a
backup b/c new data has already been input to the new server. is there a sql
statement that will allow me to merge the 2 tables?
table structure:
primary key - list of 3's in sequential order (1,2,3,4, etc.)
need to build a relationship with two columns: journal entry and date
missing data is a column called aatrxsource
thanks,
jen
| |
| Hugo Kornelis 2006-01-27, 8:24 pm |
| On Fri, 27 Jan 2006 10:15:02 -0500, Jennifer Mar wrote:
>hi,
>
>I recently migrated a database from an old server to a new one. however, one
>of the tables didn't copy over all of the data, specifically one column. I
>have the missing data on the old server but am unable to restore from a
>backup b/c new data has already been input to the new server. is there a sql
>statement that will allow me to merge the 2 tables?
>
>table structure:
>primary key - list of 3's in sequential order (1,2,3,4, etc.)
>need to build a relationship with two columns: journal entry and date
>missing data is a column called aatrxsource
>
>thanks,
>jen
>
Hi Jen,
I think I can help, but not with these specifications. Could you please
post some CREATE TABLE statements (including all constraints!), a few
INSERT statements to illustrate how your data looks and the expected
output?
www.aspfaq.com/5006
--
Hugo Kornelis, SQL Server MVP
| |
| Jennifer Mar 2006-02-03, 1:23 pm |
| Thanks for you help. My colleague actually figured it out. Great to know
that there's support in this newsgroup!
"Hugo Kornelis" <hugo@perFact.REMOVETHIS.info> wrote in message
news:ro9lt1103k94mfe
t3n77019sfh9ri4k12e@
4ax.com...
> On Fri, 27 Jan 2006 10:15:02 -0500, Jennifer Mar wrote:
>
one[color=darkred]
I[color=darkred]
sql[color=darkred]
>
> Hi Jen,
>
> I think I can help, but not with these specifications. Could you please
> post some CREATE TABLE statements (including all constraints!), a few
> INSERT statements to illustrate how your data looks and the expected
> output?
>
> www.aspfaq.com/5006
>
> --
> Hugo Kornelis, SQL Server MVP
|
|
|
|
|