Use this as a basis for writing your update query:

create table #MyTable(

RowId int,

RowDataCol1 char(10)

)

go

insert into #MyTable (RowId, RowDataCol1)

select 1, 'Data 1' union

select...

How are new rows added to the table, and when do they get numbered?

If you could provide the DDL for the tables (at least the key fields plus any non key fields used in the joins), some sample data (based on the DDL...

Sql Student (4/1/2008)

---

I got 2 tables where there are matching records.

But i need to pull out data from table 2 that is not present in table 1 along with the...

Are the row numbers the only way to identify the rows? Does the table have any other means to identify the order the data was entered?

SAMPLE DATA, TABLE DDL,...

If DC means Domain Controllers, my advice is to get the databases of them and onto their own dedicated server(s).

😎

Okay, I guess we are missing the point, so show us. Please provide the DDL for the table, sample data (in the form of an insert statement with union...

I have to agree with Grant and Steve. In our DW project, I have seperated the system tables ([PRIMARY]) from the data [DATA], default), non-clustered indexes ([Indexes]), and indexed...

Are you renumbering the rows after every insert, or are you looking for a means to update the row_number field as records are inserted? Can more than one row...

Definately agree with you Matt, I need a nap now too.

😎

How about post the DDL for the tables, some sample data for each table (in the form of an insert statement with union all select statements), and what the output...

Another solution is this:

create table dbo.patient (

pt_id int,

pt_name varchar(20),

pt_dob datetime

)

go

create table dbo.charge (

ch_id int,

...

The DDL for the tables, some sample data, and the expected output based on the sample data would be helpful.

😎

I would say having a degree is worthwhile, but I would not persue it just to "filling a check box". I struggled to earn my BS degree while working...

I have gone out to confirm the issue. Thanks for the link.

😎