See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.
Select hr.res_id ,hr.fullname ,hr.usr_id ,jt.descr50 ,hr.comp ,hr.job_title ,hr.loc , cicmpy.cmp_fadd1 as address , cicmpy.cmp_tel as phone , cicmpy.cmp_fax as fax , cicmpy.cmp_fcity COLLATE DATABASE_DEFAULT+ ', ' + cicmpy.statecode COLLATE DATABASE_DEFAULT+ ' ' + cicmpy.cmp_fpc COLLATE DATABASE_DEFAULT as citystate ,hr.ldatindienst ,hr.emp_stat ,hr.costcenter ,a.itemcode ,i.userYesNo_01 ,a.enddate From humres as hr left join (absences a inner join items i on i.itemcode = a.itemcode and i.userYesNo_01 = 1) on hr.res_id = a.empid and a.type = 86 left join hrjbtl as jt on hr.job_title = jt.job_title -- left join cicmpy ON hr.comp= cicmpy.administration and cicmpy.cmp_type = 'D' where usr_id = 'T0798' -- Order by hr.res_id
|Return rows that match the first row||3||33|
|No match in target code page Error. (when inserting into SQL table)||12||58|
|SQL Server; storing data in offline mode.||10||47|
|Two tables - Sum of values - What is the difference||31||40|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
17 Experts available now in Live!