Thanks Ramesh, I forgot variables could be assigned that way.

Cheers,

Chris

Manage to solve it myself - missing the brackets.

Should be: SET @Tmp = (SELECT TOP 1 Value FROM Table ORDER BY NewID())

I am not sure exactly what you want to do with it but this should give you some idea of how it could be achieved by turning the...

Hi There,

 -- What you need to do  for an insert is the following:

insert into tbl1

(port)

Select tbl2.port from tbl2 INNER JOIN tbl1 ON tbl1.ship_id = tbl2.ship_id

-- If it is an update...