Thanks Luis! I'm sure that'll get me going.

Resolved. Thanks

Thanks Ron! I was just working on the Temp table approach. Will try and post back....

OK. Thanks. I am pulling from a poorly built table and database and inserting into a new database and tables. All works fine except for the source...

Sorry. Dealing with thousands of records and a few to several hundred are duplicates so TOP 1 wouldn't work.

The only thing I can come up with so...

This seems to mostly work:

RIGHT(LastName,(LEN(LastName))-CHARINDEX(',',LastName)) As FirstNameOnly

I needed to use Right Trim but I didn't know how many positions to trim to. So, I did this:

Right(LastName, C)

A = Length...

Makes sense now. I kept typing THEN just by nature...only to have to go back and delete it.

Thanks!

I'm mostly a VB.NET guy so those same rules don't apply. I am slowly teaching myself C# though so I'm sure I would have come across that in C#...

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- ==========================================================================================

-- This Stored Procedure is designed to insert Owner data, known as "Dealership Owner"

-- in OnBoard into the Persons and Owners tables.

-- ==========================================================================================

ALTER PROCEDURE [dbo].[sp_InsertOwnersFromOnboard]...

Thanks Sean. I've tried all that. Been trying to work this out for the past couple of hours and just can't come up with something SSMS will accept....

Thanks Mark. I think my basic design was flawed too. I moved the FK in the Accounts Table. The Account belongs to the customer. Not the...

Thanks guys. Both solutions were almost identical and I was able to get them both to work. It seems I was over complicating the process. Thanks again!

I'll be glad to try these samples tomorrow. I'll post results. Always willing to learn and improve....

After much tinkering and research, I think I have a prototype that works. Ended up using a cursor and parameters. It's not bulletproof but so far, this...

Thanks. Volume isn't an issue as this will be a one time load. But my logic is certainly questionable! =)

Logic is simple.

Take records from old table and insert...