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 BusinessUnitName, isnull(,0) as [ClickCount July], isnull(,0) as [ClickCount August], isnull(,0) as [ClickCount September] FROM ( SELECT B.BusinessUnitName , sm.Visits, datediff(MONTH, sm.EntryTime, getdate()) AS [AgedMonth] FROM bridgetrack.dbo.VIEW_Summary_Month SM WITH (NOLOCK) JOIN bridgetrack.dbo.BUSINESSUNITS B WITH (NOLOCK) ON SM.BusinessUnitID = B.BusinessUnitID WHERE TARGETID IN (SELECT TargetID FROM #temp_targets T ) AND EntryTime >= dateadd(m,datediff(m,0,getdate())-3,0) -- could use between, but sometimes easier to manage this way AND EntryTime < dateadd(m,datediff(m,0,getdate()),0) ) src PIVOT ( sum(Visits) for [AgedMonth] in (,,) ) Pvt ORDER BY BusinessUnitName
|replace quotes with UTF-8 character||38||59|
|Multiple Max Statements||11||21|
|Access - Calculate value of a field based on value of another in the same table||6||24|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!