Thanks all!

That's what I was thinking should work but it didn't. I just come to find out some of the teacher names were entered with spaces. That's why they...

Thanks

Thanks to the both of you.

Sean, your my kind of coder ...

Sean, John - It looks like I can more problems than just one field. I'm going back to the import but set the key fields first. Inheriting databases...

-- is there some sort of ID column? --> No

-- what data type is the field that can be null? --> NVARCHAR

-- are there students who have...

That did it! I could have sworn I try this method but I'll have to go back tand check my notes. Thanks to the both of you for...

I still receive: Msg 512, Level 16, State 1, Line 1

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= ,...

I tweaked the code to add the comma and crt_concept alias to the select statements.

The combination of test_uniq, concept_id, test_id is unique since the following does not return any rows.

select...

FINALLY!!! I found I was logged into the SQL Server using Windows authentication. My create linkserver script, the @locallogin was set to 'sa'. Once I disconnected to the...

TNSNAMES.ORA and SQLNET.ORA appear to be configured properly.

--------------------------------------------------------------------------------------

# sqlnet.ora Network Configuration File: E:\oracle\product\10.2.0\client_1etwork\admin\sqlnet.ora

# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to...

Sorry. Wrong forum ...

THANKS! I seem to try and make it more difficult than it needs to be. Really appreciate the these forums and the what I learned from them.

K

D'OH! I hope that was a result of my cold medicine and not a serious brain problem. Works just fine. Thanks.