Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.
SELECT *, ROW_NUMBER() OVER (ORDER BY Due_Date DESC) as Row FROM #OutputTable WHERE ISNULL(IsCompleted,0)=0 AND [TYPE_ID] IN (4,5) ORDER BY Due_Date DESC CREATE TABLE #OutputTable ( Task_ID int, Item_ID int, [Type_ID] int, Task_Title varchar(500), Priority_ID int, Due_Date datetime, TaskType_ID int, TaskRef_ID int, Tags varchar(500), Creator varchar(200), Created datetime, LastUpdated datetime, Ident int, IsCompleted bit, Duration_ID int, OwnerType_ID int, OwnerTypeItem_ID varchar(200), Company_ID int, TaskType_Name varchar(200), Priority_Name varchar(200), LinkedEntity varchar(200), AppointmentStatus_ID int, IsFlagged bit )
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!