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 CASE WHEN @groupBy = 1 THEN 'Salesperson: ' WHEN @groupBy = 2 THEN 'Third Party Salesperson: ' END + ISNULL(gb.Name1 + ' (' + gb.Code + ')', '(none)') as GroupByName, SubmittedByName, CurrentMonth from @loanInfoTotals t left join Entity gb on (@groupBy = 0 and 1 = 2) or (@groupBy = 1 and gb.PartyId = t.SalespersonId) or (@groupBy = 2 and gb.PartyId = t.ThirdPartySalespersonId)
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!