We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
SELECT * FROM (SELECT Incident_ID AS [Ticket Number], CONVERT(datetime, DateClosed / 86402.027 + 25567) AS [Date Closed], AssignedGroup AS [Assigned Group], AssignedTechnician AS [Assigned Technician], CASE Priority WHEN 4 THEN 'Low' WHEN 3 THEN 'Medium' WHEN 2 THEN 'High' END AS Priority, CASE Status WHEN 3 THEN 'Closed' WHEN 8 THEN 'Drill Status' WHEN 4 THEN 'Hold' WHEN 1 THEN 'Assigned' WHEN 0 THEN 'New' WHEN 9 THEN 'Project' END AS Status, CONVERT(datetime, Date_Opened / 86402.027 + 25567) AS [Date Opened], CASE COMPLEXITY WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' END AS [Suspense Missed] FROM dbo.TTS_Main) derived WHERE (Status <> 'Closed') AND ([Date Opened] <= DATEADD(dd, - 8, DATEDIFF(dd, 0, GETDATE()))) AND (Status <> 'Project')
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Why do I get the message "Message has been thrown by target of an invocation"?||22||90|
|SQL Query help||3||37|
|Problem with MySQL query - graph||3||41|
|T-SQL Query - Group By Year||3||54|
Join the community of 500,000 technology professionals and ask your questions.