OMG, It worked with a few modifications........I have worked for weeks on this trying to figure this out.  Yall are AWESOME and I appreciate you very much.

I am receiving the below error after adding

update contact2

set udefcon =

(select 1

from

contact2 sub2, contact1 sub1

WHERE sub1.accountno = sub2.accountno

AND sub2.accountno = contact2.accountno

ERROR:  Server: Msg 116, Level 16, State 1, Line...

Hi All,

Question:  I am receiving the below error when I added the "update" to the first of my script:

Subquery returned more than 1 value. This is not permitted when the...

WOW-Thank you so much

EXAMPLE:

Table Name:  contact2

Columns: 

accountno varchar(20) NOT NULL (000001234) (unique identifier)

unamefull varchar(50) NULL

uactequiv smallinit, null

userdef02 varchar20 null

userdef03 varchar20 null

If a person has a score in uactequiv that is between 1-19 they...

Do I just need to FETCH?

How would I calculate the total score at the end of the stored procedure

Thank you so much!  That is exactly what I needed

Thank you, Thank you, Thank you

Everyone who is 16 within the week

Here is an example of the date in the contact2 table - column ubirthday

1986-12-08 00:00:00.000

1986-10-28 00:00:00.000

1986-03-31 00:00:00.000

1986-11-21 00:00:00.000

Thank everyone so much for the help.  I was able to correct my problem.  You are all appreciated very much.  Your knowledge is just amazing.  Thanks for the mentoring.

 I need to find a way to execute a procedure stored in an Oracle database using a DTS package in SQL Server 2000.  I can query, insert, and update...

It worked.  Thank you so much.

Steve,

I am wanting to create my own tables in SQL2000 that will populate information that is stored in an Oracle DB.  Example:  fname, lname, mi, telephone number, e-mail address, etc. ...