I had wanted to use a single query and execution plan to update the cust_test table..........

I performed a count and count distinct across all tables, it returned the same number for all tables except the last one where there were duplicates across the reference...

I tried using a left join instead of inner join and i receive 3.18 million records now..it may be pulling extra ones

thanx sergei and lynnn, that was something new i learnt, if finally did its job and took about 3 hrs to execute!!

thanx again 🙂

I rewrote the procedure for removing the duplicate data as suggested above.

Last week, the datawarehouse went into recovery mode when i tried to restart the server.(Reason being the procedure that...

I see now, i wasn't focusing on the left join, by definition the join returns all null values from the CTE table. All you have to do then is do...

Thanks, it looks very interesting . I apologize but i did not get completely understand the last line (in bold)

SELECT RowID FROM del_dublicates Tbl1 Left Join

...

Thanks for the reply,

You're right it wouldn't be easy to diagnose with all the code at once.

However, i have executed the create table and insert table statements separately and they...

Thanks for that Doug. As i recall thats exactly what i was trying to do since i wanted to shrink the transaction log files. I have a couple of...

I am looking at the log files, it looks like the recovery started after an instance of sql system resource was started. I guess the transaction logs were full for...

I tried that, it still didnt update any rows, this is puzzling, because if i try this query

select top100 * from process pr,caadv ca

where ca.caID= pr.caID

It positively returns rowsets.

the...

No, sorry my mistake

I wanto insert values into TF.transID where tf.ID = pr.ID.

The transID comes from the pr table[thus tf.transID = pr.attemptID]

Thanks

I'm not sure if i understood the problem, but after exporting data, you could always just set the primary key manually...just right click on the column name ...click modify and...

Thanks for the advice, realistically i don't plan to give the certifications withing the next 6 months, but i hope to get it done by the end of this...

I finally got it done

I removed all duplicated from customers table, then insert corresponding addresses and ssn..annd so forth.

Created a temp table, removed the duplicates and updated the original table.

I...