>It is part of the select columns list, in other words, you're selecting the PK from your version table using the above technique.

After the first SQL, I execute another SQL like this:

UPDATE Version SET NoVersionProduction=Temp2.Numero
FROM Version
JOIN
(
SELECT VersionProduction.Numero,VersionProduction.Date,Temp.Numero AS VersionNumero FROM VersionProduction
INNER JOIN (SELECT CAST(Version.Date AS Date) AS Date,Version.Numero
FROM Version
WHERE Version.Date>'1899-12-30 00:00:00.000') Temp
ON Temp.Date=CAST(VersionProduction.Date AS Date)
) Temp2 ON Temp2.VersionNumero=Version.Numero

This works.

As for the CTE, it this SQL ANSI?