In order for me to see the message again, i would need to give it 3+ hours running, i dont have that much time for trying troubleshooting that might not...

I was waiting for the auto recovery to do its job, but after a couple hours of wait, it throwed an error saying something like the process cannot be completed....

I was about to try these things when i found out my pc was completely jammed..it wouldnt do anything..

Right after i posted my last message, i decided to leave it...

Hey guys, im stuck again..

I have already migrated all 6 million records and Ids to my normalized database. Integrity and FK constraints are set up just great. Now i'm trying...

Your query works just perfect, it took a while on my coal powered laptop but it did the work as it should, thanks for the help..Please do not close this...

tbl_newPeople store records of related people, therefore they might as well live together and have the same addressId.

tbl_Document and tbl_address data have something in common:

The same way people share...

The query you suggested did bring more than one value, which is not supposed to happen because there should be only one documentId that matches the criteria given...

Okay now im stuck again with this task..

Now that i have inserted all the corresponding addressId to each person, i have to insert another Id to this same table. I...

Your solution does the work satisfcactory, however i decided to insert the letter 'M' in all those null fields indicating that the field data is "missing". I also fixed my...

1- I created tbl_Address and inserted all distinct addresses, which gave me around 4 million records.

use tbl_newPeople

INSERT INTO tbl_address(street, house#, building, floor, city, state)

select distinct street, house#, building, floor,...

My goal is to reduce address redundancy as much as possible since it is likely that there will be people living in the same address. Both answers seem pretty accurate...

the answer its been in front of me since the beginning...

i just had to include, i just had to include this block:

DECLARE @LowerN int

...

below is all the code i have done so far, once again im going to explain whats happening with some context so that you can see where the problem is..

I...

SIMPLY AMAZING!! O.0, it brought my 1,000 names just like that, but I still need to send those names to a permanent table called Customer. This is the table design:

Customer(custId(pk),...

I found the syntax for the nested cursors here http://msdn.microsoft.com/en-us/library/ms180169.aspx