Thanks Howard.

I have located the stored procedure and will give the TRY....Catch a whirl.

Cheers...Steve

Just re read reply :doze:

The column is ntext purely because we do not know how the application will react if we changed it.

Which is a real pain for me.

There is...

Hi Sean,

just seen reply as I posted thanks, we have come to the same answer and it worked.

I join the table to itself to limit the amount of rows it...

Not sure why, but changed varchar(max) to nvarchar(max) and it all worked fine...will check it out in BOL

CELKO (10/18/2010)

---

CREATE TABLE PerformanceEvaluations

(emp_id CHAR(10) NOT NULL

REFERENCES Personnel(emp_id),

objective_nbr INTEGER NOT NULL,

PRIMARY KEY (emp_id, objective_nbr),

objective_description VARCHAR(1000) NOT NULL,

objective_status CHAR(5) NOT NULL ...

GSquared (10/15/2010)

---

I missed that you need to partition the number.

Is there a reason that the incrementing number needs to be stored in the database? Can you store a datetime...

I'm all ears

Ok thanks I will check that out. I did not know that the identity column could be based on a group of records with the same foreign keys. I thought...

Wayne,

thanks for the follow up. You are so right.

I have just had to take on some of the Accounts stuff and I have been so concerned with understanding the terminology...

Thanks for the replies guys, most helpful.

I have used a little bit of each suggestion and come up with a solution.

I have no access to the presentation layer so...

Looks like I may be a bit premature with my question. I am going to have a go at it using SSIS and fuzzy lookup, looks like it may be...

thanks Ian helped a lot.

ended up with this, if it is of any intrest.

update tbl_out_test set job_number =

(select substring(location,((dbo.CHARINDEX2('\', location,4)+1)),

((dbo.CHARINDEX2('\', location,5)) - ((dbo.CHARINDEX2('\', location,4))+1))))

where job_number =''