select databaseName, clientCode
from dbo.ClientDatabases
where clientDatabaseId =
select userName
from #_fmDatabase#.dbo.Users
where userId =
and CAST((DATEPART(SECOND, DateLastLogin) * 11000) + (DATEPART(DAYOFYEAR, DateLastLogin) * 11) AS VARCHAR) =
select broker_id
from tblBrokers
where ERPClientCode =
select data
from cdata
where cfid =
and app =