Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- update coreweb.AutomatlarmsInfo set AutomatlarmSkaDebiteras=1 where InsatsrapportId in (
- select r.InsatsRapportId from coreweb.Insatsrapporter r
- join coreweb.Handelser h on r.InsatsrapportId=h.InsatsrapportId
- join coreweb.AutomatlarmsInfo a on r.InsatsrapportId=a.InsatsrapportId
- where Tillstand in (2,3) and
- h.UtlosandeHandelse=171 and
- r.SkaDebiteras=1 and
- a.AutomatlarmSkaDebiteras is null
- )
- update coreweb.AutomatlarmsInfo set AutomatlarmSkaDebiteras=0 where InsatsrapportId in (
- select r.InsatsRapportId from coreweb.Insatsrapporter r
- join coreweb.Handelser h on r.InsatsrapportId=h.InsatsrapportId
- join coreweb.AutomatlarmsInfo a on r.InsatsrapportId=a.InsatsrapportId
- where Tillstand in (2,3) and
- h.UtlosandeHandelse=171 and
- r.SkaDebiteras=0 and
- a.AutomatlarmSkaDebiteras is null
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement