cat brain.stuff > wordpress

UPDATE Contact
SET Contact.Surname = x.Surname
FROM (
	SELECT Id, SUBSTRING(Surname, Len(Insertion) + 2, LEN(Surname) - Len(Insertion)) AS Surname
	FROM Contact
	WHERE Insertion IS NOT NULL
	AND Insertion <> ''
	AND CHARINDEX(Insertion + ' ', Surname) = 1) x
WHERE Contact.Id = x.Id;

update Contact set Contact.Surname = x.Surname from ( select Id, SUBSTRING(Surname, Len(Insertion) + 2, LEN(Surname) - Len(Insertion)) as Surname from Contact where Insertion is not null and Insertion <> '' and CHARINDEX(Insertion + ' ', Surname) = 1) x where Contact.Id = x.Id;

UPDATE c
SET c.Body = x.Body, c.Summary = x.Summary
FROM Content c
JOIN PageContent x ON c.ID = x.ID;

update c set c.Body = x.Body, c.Summary = x.Summary from Content c join PageContent x ON c.ID = x.ID;