HI
SELECT [BUS_ID]
,[BUS_AccountType]
,[BUS_BpsID]
,[BUS_PhoneNumber]
,[BUS_JobTitle]
,[BUS_Email]
,[BUS_DisplayName]
,[BUS_ManagerBpsID]
,[BUS_TSInsert]
,[BUS_TSUpdate]
,[BUS_RowVersion]
,[BUS_Picture]
FROM [BPS_Config].[dbo].[BpsUsers]
where [BUS_AccountType] = 2
Regards
HI
SELECT [BUS_ID]
,[BUS_AccountType]
,[BUS_BpsID]
,[BUS_PhoneNumber]
,[BUS_JobTitle]
,[BUS_Email]
,[BUS_DisplayName]
,[BUS_ManagerBpsID]
,[BUS_TSInsert]
,[BUS_TSUpdate]
,[BUS_RowVersion]
,[BUS_Picture]
FROM [BPS_Config].[dbo].[BpsUsers]
where [BUS_AccountType] = 2
Regards
thank you