Thank you Luke.

It worked just the way I want it.

Thank U, Thank U.

Have a wonderful weekend.

Hi,

Becuase I'm not passing the value of user_key to the stored procedure, I'm getting this error message:

Insert Error: Column name or number of supplied values does not match table definition.

The table has 2 fields: phID and PhNum.

the text file looks like this (10 digit phone numbers):

(7777777777,8888888888,5454545454,5555555555)

I have to insert these phone numbers from the text file into the

Phnum...

Table Structure:

Field1 - phID

Field2 - PhoneNum

textfile contents are 10 digit phone numbers and comma delimited.

So I have to insert all these phone numbers in the...

Hey, it's all good. I should have caught it the first time.

Thanks.

Hi,

It worked. Thank you very much.

Problem was I should be checking for

the Len(ApprovedBy) not Len(dateApproved).

Thank you one more time.

I changed the r.PK to r.requestID but it did not insert a date in the dateApproved column even though there was a value for ApprovedBy.

Below is the trigger I used:

CREATE...

I guess

Thanks.

It works when I use the INSERT and SELECT (as you suggested) in SQL Server Management Studio query pane.

Visual Studio will not allow me to create a table adapter...

The error I get is :

Subqueries are not allowed in this context. Only scalar expressions are allowed.

Thank you, Thank you!

Both suggestions work.

Thank you a million times.

I modified the Function and

it works fine, the way it should.

I appreciate your help.

The last 2 weeks has been hell for me.

Thank you, thank you.

Please take a look at the problematic table I just posted and see if you can make the code any simpler.

Notes ...

GSquared,

The table with duplicate acctID can have as much as 20 or more Ntext (which is notes to the acct. So basically, an account can have several notes that's why...