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.
update O set Verified = 'C' ,O.Reason = case when len(O.Reason) = 0 then 'Inactive Parent Order' else left(O.Reason + ', Inactive Parent Order', 255) end from dbo.Orders O join dbo.OrderHistory OH on O.ID = OH.ID and isnull(OH.ParentID,'') != '' and OH.ParentID in (select distinct PA.ParentID from dbo.dbo.OrderHistory PA where getDate() >= case when isdate(PA.INACTIVEDATE) = 1 then convert(datetime,PA.INACTIVEDATE) else '01/01/9999' end and isnull(PA.ParentID,'') != '' )
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!