SELECT TOP (1000) [LAST_FIRST]
,[LAST_NAME]
,[FIRST_NAME]
,[MIDDLE_NAME]
,[DESIGNATION]
,[PREFIX]
,[INFORMAL]
,[FULL_NAME]
,[EMAIL]
,[WORK_PHONE]
,[MemberTitle]
,[ID]
,[COMPANY]
,[CO_ID]
,[MainCompany]
,[MAIN_CO_ID]
,[EffectiveDate]
,[ExpirationDate]
,[IsDisabled]
,[UserId]
,[MEMBER_TYPE]
,[CATEGORY]
,[MemberClass]
FROM [CII_iMIS].[dbo].[CII_User_Profiles_for_Kentico]
Manage space
Manage content
Integrations