You possibly want to add a REPLACE in there as well to deal with possibility of double spaces.

initials AS (UPPER(LEFT([name],(1))+SUBSTRING(REPLACE([name],' ',' '),CHARINDEX(' ',[name],(1))+(1),(1))))

Cheers

Tim

Try this for size...

USE [SandBox]

GO

IF OBJECT_ID('tempdb.dbo.#TESTNames') IS NOT NULL

DROP TABLE #TESTNames

CREATE TABLE #TESTNames (

name VARCHAR(100) NULL,

...

There is no fast way of doing this in one operation. If you use a cursor you will have to scan the whole index for every row being updated which...

looks like that was a garden path or a red herring or something

I failed to notice that at that point @@identity is actually returning the previous identity value and not...

I just came up with a better way

You can use @@identity inside the first insert and therefore should be able to build your reference code on the fly.

I did this...

Created...

You could simply select the max value of id column and add 1

Select MAX(your_id_col) + 1 from your_table

This will work fine and if you are the only one doing...

Thanks All

This has been excercising the old grey cells for some time

Problem solved 🙂

Hi

This info for linking MySQL Server is realy helpful and I almost have it working. Unfortunately I seem to be stuck at the last hurdle.

I have a working connection to...