pwalter,

Keep your chin up. Try not to be so hard on yourself no matter how bad it gets.

Regards,

WC

Respectfully a surrogate key does not guarantee that you will not have duplicates.

Think about how User Names are stored in Active Directory.

Have you ever seen a User ID with the...

bvsc (8/9/2011)

---

@Welsh Corgi,

You are going to create a single column for User Name?

Yes, username is single column

How about a First Name, Last Name and a User Name?

It (the username) should...

It is easier to normalize than to have to write a lot of spaghetti code.

Suresh B. (8/9/2011)

---

When I try to open Test.xls as mentioned in Sumata's solution, I get error "The file you are trying to open, 'Test.xls', is in different format than specified...

Sumata's Solution is on target.

You can use SSIS which I prefer or OPENROWSET or OPENQUERY.

rk2150 (8/9/2011)

---

one user fires a query and another user fires the same query on same table.. the 1st user query runs but the second user couldnt? how to know...

Create table visitors(

Username varchar(20),

visitors varchar(6000),

visitorsThrough varchar(6000),

crDate datetime,

UpDate datetime)

and also have 10 other columns which related to the usernames..

in the process of the flow, That table have updates, inserts and few...

As suggested you need to normalize your data and you need a unique identified as a primary key for there could be more than one person with the same name.

I'm sorry but the tables in the destination database do not appear to be normalized.

I don't have the data that you have but I would step through the code.

I would convert the delete statements into select statements and order by CompanyName to isolate the...

I'm curious as to whether your problem been resolved or not?

What have you done to isolate the problem?

You ay want to consider providing more information so that someone can help you.

Performance is definitely an issue when inserting a large number of records into a Oracle Table.

If you do not specify the number of records to commit Oracle does not...