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
>

"Hugo Kornelis" <hugo@perFact.REMOVETHIS.info> wrote in message
news:ro9lt1103k94mfet3n77019sfh9ri4k12e@4ax.com...
> 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