05:12:35  @@ 1, ,select b.status from Ticket_Master a join status_master b on a.status_id=b.status_id WHERE phoneno='9026774169' AND b.status!='closed' 
05:12:53  @@ 1, ,select b.status from Ticket_Master a join status_master b on a.status_id=b.status_id WHERE phoneno='9026774169' AND b.status!='closed' 
05:13:04  @@ 2, ,select b.status from Ticket_Master a join status_master b on a.status_id=b.status_id WHERE phone_no='9026774169' AND b.status!='closed' 
05:13:35  @@ 3, ,select b.status from Ticket_Master a join status_master b on a.status_id=b.status_id WHERE phone_no='9026774169' AND b.status!='closed' 
05:14:15  @@ 4, ,select b.status from Ticket_Master a join status_master b on a.status_id=b.status_id WHERE phone_no='9026774169' AND b.status!='closed' 
05:14:24  @@ 5, ,select b.status from Ticket_Master a join status_master b on a.status_id=b.status_id WHERE phone_no='9026774169' AND b.status!='closed' 
05:18:55  @@ 6, ,select SUM(CASE WHEN b.status='OPEN' THEN 1 ELSE 0 END)[Open],SUM(CASE WHEN b.status='Pending' THEN 1 ELSE 0 END)[Pending] from Ticket_Master a join status_master b on a.status_id=b.status_id WHERE phone_no='9026774169' AND b.status!='closed' 
05:19:40  @@ 7, ,select SUM(CASE WHEN b.status='OPEN' THEN 1 ELSE 0 END)[Open],SUM(CASE WHEN b.status='Pending' THEN 1 ELSE 0 END)[Pending] from Ticket_Master a join status_master b on a.status_id=b.status_id WHERE phone_no='9026774169' AND b.status!='closed' 
05:19:53  @@ 8, ,select SUM(CASE WHEN b.status='OPEN' THEN 1 ELSE 0 END)[Open],SUM(CASE WHEN b.status='Pending' THEN 1 ELSE 0 END)[Pending] from Ticket_Master a join status_master b on a.status_id=b.status_id WHERE phone_no='9026774169' AND b.status!='closed' 
05:21:23  @@ 9, ,select SUM(CASE WHEN b.status='OPEN' THEN 1 ELSE 0 END)[Open],SUM(CASE WHEN b.status='Pending' THEN 1 ELSE 0 END)[Pending] from Ticket_Master a join status_master b on a.status_id=b.status_id WHERE phone_no='9026774169' AND b.status!='closed' 
05:22:38  @@ 10, ,select SUM(CASE WHEN b.status='OPEN' THEN 1 ELSE 0 END)[Open],SUM(CASE WHEN b.status='Pending' THEN 1 ELSE 0 END)[Pending] from Ticket_Master a join status_master b on a.status_id=b.status_id WHERE phone_no='9026774169' AND b.status!='closed' 
06:15:20  @@ 1, ,select b.status,ticket_id from Ticket_Master WITH(NOLCOK) a join status_master b on a.status_id=b.status_id WHERE phone_no='9026774169' AND b.status!='closed' 
06:16:15  @@ 2, ,select b.status,ticket_id from Ticket_Master a WITH(NOLOCK) join status_master b on a.status_id=b.status_id WHERE phone_no='9026774169' AND b.status!='closed' 
