UPDATE [Negozi].[dbo].[ScontrinoT]
SET [Stato] = 'EL'
WHERE ([SyncCS] LIKE '%ELI' OR [SyncCS]='CAN') AND [Stato]='AT'

UPDATE [Negozi].[dbo].[ScontrinoT]
SET [Stato] = 'CH_EL'
WHERE ([SyncCS] LIKE '%ELI' OR [SyncCS]='CAN') AND [Stato]='CH'

UPDATE [Negozi].[dbo].[ScontrinoD]
SET [Stato] = 'EL'
WHERE ([SyncCS] LIKE '%ELI' OR [SyncCS]='CAN') AND [Stato]='AT'

UPDATE [Negozi].[dbo].[ScontrinoD]
SET [Stato] = 'CH_EL'
WHERE ([SyncCS] LIKE '%ELI' OR [SyncCS]='CAN') AND [Stato]='CH'