select ownerId, ownerType, userId, settings, settings2
from tbl_SYS_UserSettings with (nolock)
where label = 'ws:operatorAnalyzerSavedSearches' --'ws:Insights360.OpportunityAnalyzer.opportunityListSavedSearches' -- --
order by ownerId, ownerType
update tbl_SYS_UserSettings
set settings = ,
settings2 =
where ownerId =
and ownerType =
and userId =
and label = 'ws:Insights360.operatorAnalyzer.operatorAnalyzerSavedSearches'
insert into tbl_SYS_UserSettings( ownerId, ownerType, userId, label, settings, settings2 )
values( , , ,
'ws:Insights360.operatorAnalyzer.operatorAnalyzerSavedSearches',
, )