blob: 103e060644e5d55ebd018560a83bd801ce39d2ed (
plain)
1
2
3
4
|
IF COL_LENGTH('[dbo].[documento]', 'idestipulante') IS NOT NULL AND COL_LENGTH('[dbo].[controle]', 'idestipulante') IS NOT NULL
BEGIN
UPDATE documento SET idestipulante = c.idestipulante FROM documento d INNER JOIN controle c on c.idcontrole = d.idcontrole WHERE d.idestipulante is null and c.idestipulante IS NOT NULL;
END
|
