Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.
Select distinct wrap.L0, wrap.L1, wrap.L2, wrap.L3, wrap.L4, wrap.ZIPCODE from ( SELECT dbo.PeopleMailingNameCalc(LTC.People2ID) as L0, dbo.AddressCollapseReturnL1L2L3L4(1, null, LTC.PeopleAddress2ID) as L1, dbo.AddressCollapseReturnL1L2L3L4(2, null, LTC.PeopleAddress2ID) as L2, dbo.AddressCollapseReturnL1L2L3L4(3, null, LTC.PeopleAddress2ID) as L3, dbo.AddressCollapseReturnL1L2L3L4(4, null, LTC.PeopleAddress2ID) as L4, (Select (isnull(Zip,'') + ' ' + isnull(Zip4,'')) FROM dbo.PeopleAddresses2 where PeopleAddress2ID=LTC.PeopleAddress2ID) as ZIPCODE FROM Membership2 INNER JOIN Body2 ON Membership2.BodyId = Body2.BodyId INNER JOIN MembershipStatus2 ON Membership2.MembershipStatusId = MembershipStatus2.MembershipStatusId INNER JOIN People2 ON Membership2.People2Id = People2.People2ID INNER JOIN @LocTableC LTC ON LTC.People2ID = People2.People2ID WHERE (People2.DateOfDeath IS NULL) AND (Membership2.People2ID in (select People2ID from @LocTableC)) ) as wrap ORDER BY CASE WHEN @OrderBy = 'ZIP' THEN wrap.ZIPCODE ELSE wrap.L0 END
|Problem with SqlConnection||5||123|
|codeigniter query returning too many results||3||32|
|SSRS Calculation of two fields not working||7||36|
|MS SQL store procedure to calculate and return result||6||35|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!