UPDATE Users SET DisableMailNotifications = 1 WHERE Email NOT LIKE '%eqproject%' OR Email NOT LIKE '%telemedware%'
UPDATE Customers SET Email = 't@t.tt' , Phone1= '0' + replicate('0', 9 - len(CONVERT(varchar, ID))) + CONVERT(varchar, ID) , Phone2='0' + replicate('0', 9 - len(CONVERT(varchar, ID))) + CONVERT(varchar, ID)
UPDATE Opportunities SET Email = 't@t.tt', Phone2 = '1' + replicate('0', 9 - len(CONVERT(varchar, FK_Customer))) + CONVERT(varchar, FK_Customer) , Phone1 = '1' + replicate('0', 9 - len(CONVERT(varchar, FK_Customer))) + CONVERT(varchar, FK_Customer)
UPDATE SimpleVASOrders SET Email = 't@t.tt', Phone1 = '3938775351', Phone2 = '3938775351'
UPDATE Leads SET Email = 't@t.tt' , PhoneNumber= '2' + replicate('0', 9 - len(CONVERT(varchar, ID))) + CONVERT(varchar, ID), CellphoneNumber = '2' + replicate('0', 9 - len(CONVERT(varchar, ID))) + CONVERT(varchar, ID)

--CANCELLAZIONE DI TUTTI I MEDIA CHE STANNO NELL'ANAGRAFICA "DOCUMENTI" 
DELETE FROM ProductMedias 
DELETE FROM OrderDetailMedias 
DELETE FROM Medias WHERE TypeDocument IN (71,72,73,74,75,76,77,78,79)

--REPLACE LINK STATICI URANIA
UPDATE DBO.Opportunities SET
OtpLink = REPLACE(OtpLink,'urania','uraniatest')
WHERE OtpLink IS NOT NULL

UPDATE DBO.Opportunities SET
CustomerDocumentsLink = REPLACE(CustomerDocumentsLink,'urania','uraniatest')
WHERE CustomerDocumentsLink IS NOT NULL

UPDATE dbo.AppointmentRequests SET
TestingHesitationLink =REPLACE(TestingHesitationLink,'urania','uraniatest')
WHERE TestingHesitationLink IS NOT NULL

UPDATE dbo.BoilerMaintenances SET
MaintenanceHesitationLink = REPLACE(MaintenanceHesitationLink,'urania','uraniatest')
where MaintenanceHesitationLink IS NOT NULL