→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎07-24-2017 06:20 PM
‎08-21-2017 08:43 PM
‎08-03-2017 01:15 PM
Select Distinct htblticket.ticketid,
'#' + Cast(htblticket.ticketid As nvarchar) As Ticket,
htblticket.subject,
htblticket.date As [Creation Date],
htblusers.name As [Ticket Creator]
From htblticket
Inner Join htblusers On htblusers.userid = htblticket.fromuserid,
htblbusinesshours
Where (DatePart(hh, htblticket.date) < DatePart(hh, htblbusinesshours.mon)) Or
(DatePart(hh, htblticket.date) > DatePart(hh, htblbusinesshours.mon2))
Order By htblticket.ticketid DESC
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now