not taking second condition
Select Top 1000000 htblticket.ticketid, '#' + Cast(htblticket.ticketid As nvarchar) As Ticket, htblusers1.name As AssignedAgent, htblticket.date As CreationDate, htblticket.updated As LastUpdated, '../helpdesk/icons/' + htbltickettypes.icon As i...