UPDATE Custom_Tabs Set Tabs_Caption = N'SolutionDELETE' Where Tabs_TabId <>
(SELECT MIN (Tabs_TabId) FROM Custom_Tabs WHERE tabs_Deleted is null AND
( Tabs_Entity = N'find' and Tabs_DeviceID is null and Tabs_InButtonGroup is null and
COALESCE(Tabs_Action, N'') <> N'newaccount' and Tabs_Caption = N'Solution'))
AND tabs_Deleted is null AND ( Tabs_Entity = N'find' and Tabs_DeviceID is null and
Tabs_InButtonGroup is null and COALESCE(Tabs_Action, N'') <> N'newaccount' and Tabs_Caption = N'Solution')
No comments:
Post a Comment