Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them.
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 )
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.