06:13:09  @@ 1, , SELECT TOP 1 (select top 1 status_id from status_master where status='Open')Status_id,a.queue_id,emailaccount_id,email_id,(SELECT TOP 1 category_id FROM category_master WHERE NAME='')Category  from queue_master a JOIN emailaccount_master b ON a.default_account_id=b.emailaccount_id where a.name='test' AND a.isactive=1  
06:13:09  @@ 2, ,select isqueuewiseprefix from company_setup with(nolock)
06:13:09  @@ 3, ,select ticket_prefix from queue_master with(nolock) where queue_id=8
06:13:09  @@ 4, ,SELECT top 1 CASE WHEN IsCustomerEmail = 1 THEN ISNULL(email_subject,'') ELSE '' END email_subject,
                                    CASE WHEN IsCustomerEmail = 1 THEN ISNULL(template_body,'') ELSE '' END template_body,
                                    CASE WHEN IsCustomerSMS = 1 THEN ISNULL(sms_template_body,'') ELSE '' END sms_template_body,
                                    CASE WHEN IsUserEmail = 1 THEN ISNULL(email_subject_user,'') ELSE '' END email_subject_user,
                                    CASE WHEN IsUserEmail = 1 THEN ISNULL(template_body_user,'') ELSE '' END template_body_user,
                                    CASE WHEN IsUserSMS = 1 THEN ISNULL(sms_template_body_user,'') ELSE '' END sms_template_body_user
                                    FROM Queue_Template_Grid a JOIN template_master b ON a.Template_Id = b.template_id WHERE Queue_Id = 8 AND Actions = 'Open'
06:13:09  @@ 5, ,INSERT INTO Ticket_Master(Happy_Code,subject,ticket_prefix,start_mode,start_date,customer_name,unique_id,phone_no,queue_id,category_id, subcategory_id,[from],[to],cc,bcc,priority_id,status_id,assigned_to,isassigned,assigned_by,assigned_on,ticket_created_by)values( '2017','','TT','On Call',GETDATE(),'', NULL,'9026774169','8', '0',0,'','test@sansoftwares.com',NULL,NULL,NULL,  '3',NULL,NULL,'',GETDATE(),'');SELECT SCOPE_IDENTITY()
06:13:09  @@ 6, ,UPDATE Ticket_Master SET ticket_id='[#TT200808-11149]',subject=' Ticket Id :- [#TT200808-11149]' where ticket_unique_id=11149
06:13:09  @@ 7, ,INSERT INTO conversation_master(conversation_date,conversation_type,ticket_unique_id,ticket_id,phone_no,account_id,[from],[to],cc,bcc,subject,sms_conversation,category_id,subcategory_id,status_id,priority_id,queue_id,login_id,email_status,sms_status,no_of_try,max_try,email_message_id) values(GETDATE(),'On Call','11149','[#TT200808-11149]','9026774169', '5','test@sansoftwares.com','',NULL, NULL,N'',null, '0',NULL, '3',NULL, '8','','none','none',0,0,'f422aa78354247b9b485aa04ccc59c60');select SCOPE_IDENTITY(); EXEC DBO.USP_INS_TICKET_LOG '11149','','New Ticket','New ticket generated On call' 
06:13:09  @@ 8, ,INSERT INTO conversation_master(conversation_date,conversation_type,ticket_unique_id,ticket_id,phone_no,account_id,[from],[to],cc,bcc,subject,sms_conversation,category_id,subcategory_id,status_id,priority_id,queue_id,login_id,email_status,sms_status,no_of_try,max_try,email_message_id) values(GETDATE(),'Auto Reply Email','11149','[#TT200808-11149]','9026774169', '5','test@sansoftwares.com','',NULL, NULL,N' Ticket Id :- [#TT200808-11149]',N'', '0',NULL, '3',NULL, '8','','NEW','',0,0,'72d5b3bfb2b9416e82aaafc762404868');select SCOPE_IDENTITY(); EXEC DBO.USP_INS_TICKET_LOG '11149','','Manual Reply','Auto Reply Manual' 
06:13:09  @@ 9, ,select top 1 isnull(IsManual_Assign,0)IsManual_Assign from company_setup 
06:13:09  @@ 10, ,SELECT top 1 CASE WHEN IsCustomerEmail = 1 THEN ISNULL(email_subject,'') ELSE '' END email_subject,
                                    CASE WHEN IsCustomerEmail = 1 THEN ISNULL(template_body,'') ELSE '' END template_body,
                                    CASE WHEN IsCustomerSMS = 1 THEN ISNULL(sms_template_body,'') ELSE '' END sms_template_body,
                                    CASE WHEN IsUserEmail = 1 THEN ISNULL(email_subject_user,'') ELSE '' END email_subject_user,
                                    CASE WHEN IsUserEmail = 1 THEN ISNULL(template_body_user,'') ELSE '' END template_body_user,
                                    CASE WHEN IsUserSMS = 1 THEN ISNULL(sms_template_body_user,'') ELSE '' END sms_template_body_user
                                    FROM Queue_Template_Grid a JOIN template_master b ON a.Template_Id = b.template_id WHERE Queue_Id = 8 AND Actions = 'Manual Assign'
06:13:09  @@ 11, , BEGIN TRANSACTION [Tran1]  BEGIN TRY  IF OBJECT_ID('tempdb..#TEMP') IS NOT NULL DROP TABLE #TEMP  IF OBJECT_ID('tempdb..#ConvTemp') IS NOT NULL DROP TABLE #ConvTemp  SELECT ROW_NUMBER() OVER(PARTITION BY ticket_unique_id ORDER BY conversation_id) ROW,conversation_id,email_message_id  ,[subject],ticket_unique_id INTO #ConvTemp  FROM conversation_master a WITH(NOLOCK,INDEX(conversation_master_ticket_unique_id)) JOIN[dbo].[Split] ('11149',',') F ON a.ticket_unique_id = F.Data  DELETE FROM #ConvTemp WHERE ROW !=1  DECLARE @temp as table(conversation_id int)  UPDATE A SET assigned_to=,isassigned=1,assigned_by=0 FROM TICKET_MASTER A JOIN [dbo].[Split]('11149',',') F ON a.ticket_unique_id = F.Data  SELECT b.category_id,b.subcategory_id,GETDATE() date,B.ticket_unique_id,B.ticket_id,Send_Account_Id,email_id,customer_name,b.[from],  ISNULL(e.IsHappyCode,0)IsHappyCode,b.Happy_Code,b.[to],b.CC,c.subject,B.status_id,B.priority_id,B.queue_id,B.phone_no,assigned_to,c.email_message_id Pre_email_message_id INTO #TEMP  FROM Ticket_Master B WITH(NOLOCK)  JOIN #ConvTemp c ON c.ticket_unique_id=b.ticket_unique_id JOIN queue_master E WITH(NOLOCK) ON E.queue_id = B.queue_id  JOIN emailaccount_master G WITH(NOLOCK) ON G.emailaccount_id = E.Send_Account_Id INSERT INTO Conversation_Master(category_id,subcategory_id,SMS_max_try,max_try,Conversation_Date,Conversation_Type,ticket_unique_id,Ticket_Id,Account_Id,[From],[To],Cc,Subject,Status_Id,Priority_Id,Queue_Id,Login_Id,Email_Status,No_Of_Try,email_message_id,sms_conversation,sms_status,SMS_no_of_try,phone_no) OUTPUT Inserted.conversation_id  INTO @temp  SELECT category_id,subcategory_id,0,0,GETDATE(),'Manual Assign Customer',B.ticket_unique_id,B.ticket_id,Send_Account_Id,email_id,B.[from]+ CASE WHEN LEN(REPLACE(REPLACE(REPLACE(REPLACE(b.[to],','+email_id,''),email_id+',',''),','+email_id+',',''),email_id,''))=0 THEN '' ELSE ','+REPLACE(REPLACE(REPLACE(REPLACE(b.[to],','+email_id,''),email_id+',',''),','+email_id+',',''),email_id,'') END ,B.CC,REPLACE( REPLACE( REPLACE( REPLACE( REPLACE('##subject## Ticket Id :- ##ticketid##','##ticketid##',B.ticket_id) ,'##subject##',b.subject) ,'##Mobile##',ISNULL(B.phone_no,'')) ,'##Agent_Name##',ISNULL(c.name,'')) ,'##CustomerName##',ISNULL(b.customer_name,'')),B.status_id,B.priority_id,B.queue_id,0,'NEW',0,REPLACE(NEWID(),'-',''), NULL  ,'none' ,0,B.phone_no FROM #TEMP B  JOIN User_Master c WITH(NOLOCK) ON b.assigned_to=c.user_id  UNION ALL  SELECT category_id,subcategory_id,0,0,GETDATE(),'Manual Assign Agent',B.ticket_unique_id,B.ticket_id,Send_Account_Id,email_id,c.email  ,'',REPLACE( REPLACE( REPLACE( REPLACE( REPLACE('Ticket Id :- ##ticketid##  is Assigned','##ticketid##',B.ticket_id) ,'##subject##',b.subject) ,'##Mobile##',ISNULL(B.phone_no,'')) ,'##Agent_Name##',ISNULL(c.name,'')) ,'##CustomerName##',ISNULL(b.customer_name,'')),B.status_id,B.priority_id,B.queue_id,0,'NEW',0,REPLACE(NEWID(),'-',''),REPLACE( REPLACE( REPLACE( REPLACE( REPLACE('Hi ##Agent_Name##,

Ticket Id :- ##ticketid## is assigned to you.

##remarks##','##ticketid##',B.ticket_id) ,'##subject##',b.subject) ,'##Mobile##',ISNULL(B.phone_no,'')) ,'##Agent_Name##',ISNULL(c.name,'')) ,'##CustomerName##',ISNULL(b.customer_name,'')) ,'NEW' ,0,c.phoneno FROM #TEMP B  JOIN User_Master c WITH(NOLOCK) ON b.assigned_to=c.user_id WHERE ISNULL(c.email,'')!='';  insert into AssignLogs(TicketId,AssignedBy,AssignedTo,LastAssigned,AssignedOn)  SELECT ticket_unique_id , 0,,assigned_to,Getdate() FROM #TEMP ; SELECT a.subject,a.cc,a.[to],a.[from],a.email_message_id,a.conversation_type,  c.Pre_email_message_id,c.ticket_id,c.phone_no,d.name,c.customer_name,d.signature,c.ticket_unique_id  ,c.cc Pri_cc,c.[from] Pri_from,c.[to] Pri_to,c.Happy_Code,ISNULL(c.IsHappyCode,0)IsHappyCode,c.assigned_to,c.email_id  FROM conversation_master a JOIN @temp b ON a.conversation_id=b.conversation_id  JOIN #TEMP c ON c.ticket_unique_id=a.ticket_unique_id  JOIN User_Master d WITH(NOLOCK) ON c.assigned_to=d.user_id  COMMIT TRANSACTION [Tran1]  END TRY  BEGIN CATCH ROLLBACK TRANSACTION[Tran1] END CATCH 
06:17:57  @@ 35, , SELECT TOP 1 (select top 1 status_id from status_master where status='Open')Status_id,a.queue_id,emailaccount_id,email_id,(SELECT TOP 1 category_id FROM category_master WHERE NAME='')Category  from queue_master a JOIN emailaccount_master b ON a.default_account_id=b.emailaccount_id where a.name='test' AND a.isactive=1  
06:17:57  @@ 36, ,select isqueuewiseprefix from company_setup with(nolock)
06:17:57  @@ 37, ,select ticket_prefix from queue_master with(nolock) where queue_id=8
06:17:57  @@ 38, ,SELECT top 1 CASE WHEN IsCustomerEmail = 1 THEN ISNULL(email_subject,'') ELSE '' END email_subject,
                                    CASE WHEN IsCustomerEmail = 1 THEN ISNULL(template_body,'') ELSE '' END template_body,
                                    CASE WHEN IsCustomerSMS = 1 THEN ISNULL(sms_template_body,'') ELSE '' END sms_template_body,
                                    CASE WHEN IsUserEmail = 1 THEN ISNULL(email_subject_user,'') ELSE '' END email_subject_user,
                                    CASE WHEN IsUserEmail = 1 THEN ISNULL(template_body_user,'') ELSE '' END template_body_user,
                                    CASE WHEN IsUserSMS = 1 THEN ISNULL(sms_template_body_user,'') ELSE '' END sms_template_body_user
                                    FROM Queue_Template_Grid a JOIN template_master b ON a.Template_Id = b.template_id WHERE Queue_Id = 8 AND Actions = 'Open'
06:17:57  @@ 39, ,INSERT INTO Ticket_Master(Happy_Code,subject,ticket_prefix,start_mode,start_date,customer_name,unique_id,phone_no,queue_id,category_id, subcategory_id,[from],[to],cc,bcc,priority_id,status_id,assigned_to,isassigned,assigned_by,assigned_on,ticket_created_by)values( '4709','','TT','On Call',GETDATE(),'', NULL,'9026774169','8', '0',0,'','test@sansoftwares.com',NULL,NULL,NULL,  '3',NULL,NULL,'',GETDATE(),'');SELECT SCOPE_IDENTITY()
06:17:57  @@ 40, ,UPDATE Ticket_Master SET ticket_id='[#TT200808-11150]',subject=' Ticket Id :- [#TT200808-11150]' where ticket_unique_id=11150
06:17:57  @@ 41, ,INSERT INTO conversation_master(conversation_date,conversation_type,ticket_unique_id,ticket_id,phone_no,account_id,[from],[to],cc,bcc,subject,sms_conversation,category_id,subcategory_id,status_id,priority_id,queue_id,login_id,email_status,sms_status,no_of_try,max_try,email_message_id) values(GETDATE(),'On Call','11150','[#TT200808-11150]','9026774169', '5','test@sansoftwares.com','',NULL, NULL,N'',null, '0',NULL, '3',NULL, '8','','none','none',0,0,'66fbb9093bd94d20b3cefdfabeea9298');select SCOPE_IDENTITY(); EXEC DBO.USP_INS_TICKET_LOG '11150','','New Ticket','New ticket generated On call' 
06:17:57  @@ 42, ,select top 1 isnull(IsManual_Assign,0)IsManual_Assign from company_setup 
06:17:57  @@ 43, ,SELECT top 1 CASE WHEN IsCustomerEmail = 1 THEN ISNULL(email_subject,'') ELSE '' END email_subject,
                                    CASE WHEN IsCustomerEmail = 1 THEN ISNULL(template_body,'') ELSE '' END template_body,
                                    CASE WHEN IsCustomerSMS = 1 THEN ISNULL(sms_template_body,'') ELSE '' END sms_template_body,
                                    CASE WHEN IsUserEmail = 1 THEN ISNULL(email_subject_user,'') ELSE '' END email_subject_user,
                                    CASE WHEN IsUserEmail = 1 THEN ISNULL(template_body_user,'') ELSE '' END template_body_user,
                                    CASE WHEN IsUserSMS = 1 THEN ISNULL(sms_template_body_user,'') ELSE '' END sms_template_body_user
                                    FROM Queue_Template_Grid a JOIN template_master b ON a.Template_Id = b.template_id WHERE Queue_Id = 8 AND Actions = 'Manual Assign'
06:17:57  @@ 44, , BEGIN TRANSACTION [Tran1]  BEGIN TRY  IF OBJECT_ID('tempdb..#TEMP') IS NOT NULL DROP TABLE #TEMP  IF OBJECT_ID('tempdb..#ConvTemp') IS NOT NULL DROP TABLE #ConvTemp  SELECT ROW_NUMBER() OVER(PARTITION BY ticket_unique_id ORDER BY conversation_id) ROW,conversation_id,email_message_id  ,[subject],ticket_unique_id INTO #ConvTemp  FROM conversation_master a WITH(NOLOCK,INDEX(conversation_master_ticket_unique_id)) JOIN[dbo].[Split] ('11150',',') F ON a.ticket_unique_id = F.Data  DELETE FROM #ConvTemp WHERE ROW !=1  DECLARE @temp as table(conversation_id int)  UPDATE A SET assigned_to=,isassigned=1,assigned_by=0 FROM TICKET_MASTER A JOIN [dbo].[Split]('11150',',') F ON a.ticket_unique_id = F.Data  SELECT b.category_id,b.subcategory_id,GETDATE() date,B.ticket_unique_id,B.ticket_id,Send_Account_Id,email_id,customer_name,b.[from],  ISNULL(e.IsHappyCode,0)IsHappyCode,b.Happy_Code,b.[to],b.CC,c.subject,B.status_id,B.priority_id,B.queue_id,B.phone_no,assigned_to,c.email_message_id Pre_email_message_id INTO #TEMP  FROM Ticket_Master B WITH(NOLOCK)  JOIN #ConvTemp c ON c.ticket_unique_id=b.ticket_unique_id JOIN queue_master E WITH(NOLOCK) ON E.queue_id = B.queue_id  JOIN emailaccount_master G WITH(NOLOCK) ON G.emailaccount_id = E.Send_Account_Id INSERT INTO Conversation_Master(category_id,subcategory_id,SMS_max_try,max_try,Conversation_Date,Conversation_Type,ticket_unique_id,Ticket_Id,Account_Id,[From],[To],Cc,Subject,Status_Id,Priority_Id,Queue_Id,Login_Id,Email_Status,No_Of_Try,email_message_id,sms_conversation,sms_status,SMS_no_of_try,phone_no) OUTPUT Inserted.conversation_id  INTO @temp  SELECT category_id,subcategory_id,0,0,GETDATE(),'Manual Assign Customer',B.ticket_unique_id,B.ticket_id,Send_Account_Id,email_id,B.[from]+ CASE WHEN LEN(REPLACE(REPLACE(REPLACE(REPLACE(b.[to],','+email_id,''),email_id+',',''),','+email_id+',',''),email_id,''))=0 THEN '' ELSE ','+REPLACE(REPLACE(REPLACE(REPLACE(b.[to],','+email_id,''),email_id+',',''),','+email_id+',',''),email_id,'') END ,B.CC,REPLACE( REPLACE( REPLACE( REPLACE( REPLACE('##subject## Ticket Id :- ##ticketid##','##ticketid##',B.ticket_id) ,'##subject##',b.subject) ,'##Mobile##',ISNULL(B.phone_no,'')) ,'##Agent_Name##',ISNULL(c.name,'')) ,'##CustomerName##',ISNULL(b.customer_name,'')),B.status_id,B.priority_id,B.queue_id,0,'NEW',0,REPLACE(NEWID(),'-',''), NULL  ,'none' ,0,B.phone_no FROM #TEMP B  JOIN User_Master c WITH(NOLOCK) ON b.assigned_to=c.user_id  UNION ALL  SELECT category_id,subcategory_id,0,0,GETDATE(),'Manual Assign Agent',B.ticket_unique_id,B.ticket_id,Send_Account_Id,email_id,c.email  ,'',REPLACE( REPLACE( REPLACE( REPLACE( REPLACE('Ticket Id :- ##ticketid##  is Assigned','##ticketid##',B.ticket_id) ,'##subject##',b.subject) ,'##Mobile##',ISNULL(B.phone_no,'')) ,'##Agent_Name##',ISNULL(c.name,'')) ,'##CustomerName##',ISNULL(b.customer_name,'')),B.status_id,B.priority_id,B.queue_id,0,'NEW',0,REPLACE(NEWID(),'-',''),REPLACE( REPLACE( REPLACE( REPLACE( REPLACE('Hi ##Agent_Name##,

Ticket Id :- ##ticketid## is assigned to you.

##remarks##','##ticketid##',B.ticket_id) ,'##subject##',b.subject) ,'##Mobile##',ISNULL(B.phone_no,'')) ,'##Agent_Name##',ISNULL(c.name,'')) ,'##CustomerName##',ISNULL(b.customer_name,'')) ,'NEW' ,0,c.phoneno FROM #TEMP B  JOIN User_Master c WITH(NOLOCK) ON b.assigned_to=c.user_id WHERE ISNULL(c.email,'')!='';  insert into AssignLogs(TicketId,AssignedBy,AssignedTo,LastAssigned,AssignedOn)  SELECT ticket_unique_id , 0,,assigned_to,Getdate() FROM #TEMP ; SELECT a.subject,a.cc,a.[to],a.[from],a.email_message_id,a.conversation_type,  c.Pre_email_message_id,c.ticket_id,c.phone_no,d.name,c.customer_name,d.signature,c.ticket_unique_id  ,c.cc Pri_cc,c.[from] Pri_from,c.[to] Pri_to,c.Happy_Code,ISNULL(c.IsHappyCode,0)IsHappyCode,c.assigned_to,c.email_id  FROM conversation_master a JOIN @temp b ON a.conversation_id=b.conversation_id  JOIN #TEMP c ON c.ticket_unique_id=a.ticket_unique_id  JOIN User_Master d WITH(NOLOCK) ON c.assigned_to=d.user_id  COMMIT TRANSACTION [Tran1]  END TRY  BEGIN CATCH ROLLBACK TRANSACTION[Tran1] END CATCH 
06:20:32  @@ 1, , SELECT TOP 1 (select top 1 status_id from status_master where status='Open')Status_id,a.queue_id,emailaccount_id,email_id,(SELECT TOP 1 category_id FROM category_master WHERE NAME='')Category  from queue_master a JOIN emailaccount_master b ON a.default_account_id=b.emailaccount_id where a.name='test' AND a.isactive=1  
06:20:32  @@ 2, ,select isqueuewiseprefix from company_setup with(nolock)
06:20:32  @@ 3, ,select ticket_prefix from queue_master with(nolock) where queue_id=8
06:20:32  @@ 4, ,SELECT top 1 CASE WHEN IsCustomerEmail = 1 THEN ISNULL(email_subject,'') ELSE '' END email_subject,
                                    CASE WHEN IsCustomerEmail = 1 THEN ISNULL(template_body,'') ELSE '' END template_body,
                                    CASE WHEN IsCustomerSMS = 1 THEN ISNULL(sms_template_body,'') ELSE '' END sms_template_body,
                                    CASE WHEN IsUserEmail = 1 THEN ISNULL(email_subject_user,'') ELSE '' END email_subject_user,
                                    CASE WHEN IsUserEmail = 1 THEN ISNULL(template_body_user,'') ELSE '' END template_body_user,
                                    CASE WHEN IsUserSMS = 1 THEN ISNULL(sms_template_body_user,'') ELSE '' END sms_template_body_user
                                    FROM Queue_Template_Grid a JOIN template_master b ON a.Template_Id = b.template_id WHERE Queue_Id = 8 AND Actions = 'Open'
06:20:32  @@ 5, ,INSERT INTO Ticket_Master(Happy_Code,subject,ticket_prefix,start_mode,start_date,customer_name,unique_id,phone_no,queue_id,category_id, subcategory_id,[from],[to],cc,bcc,priority_id,status_id,assigned_to,isassigned,assigned_by,assigned_on,ticket_created_by)values( '1103','','TT','On Call',GETDATE(),'', NULL,'9026774169','8', '0',0,'','test@sansoftwares.com',NULL,NULL,NULL,  '3',NULL,NULL,'',GETDATE(),'');SELECT SCOPE_IDENTITY()
06:20:32  @@ 6, ,UPDATE Ticket_Master SET ticket_id='[#TT200808-11151]',subject=' Ticket Id :- [#TT200808-11151]' where ticket_unique_id=11151
06:20:32  @@ 7, ,INSERT INTO conversation_master(conversation_date,conversation_type,ticket_unique_id,ticket_id,phone_no,account_id,[from],[to],cc,bcc,subject,sms_conversation,category_id,subcategory_id,status_id,priority_id,queue_id,login_id,email_status,sms_status,no_of_try,max_try,email_message_id) values(GETDATE(),'On Call','11151','[#TT200808-11151]','9026774169', '5','test@sansoftwares.com','',NULL, NULL,N'',null, '0',NULL, '3',NULL, '8','','none','none',0,0,'19e41b46dde94209b90cb16f87607034');select SCOPE_IDENTITY(); EXEC DBO.USP_INS_TICKET_LOG '11151','','New Ticket','New ticket generated On call' 
06:20:58  @@ 8, ,select top 1 isnull(IsManual_Assign,0)IsManual_Assign from company_setup 
06:20:58  @@ 9, ,SELECT top 1 CASE WHEN IsCustomerEmail = 1 THEN ISNULL(email_subject,'') ELSE '' END email_subject,
                                    CASE WHEN IsCustomerEmail = 1 THEN ISNULL(template_body,'') ELSE '' END template_body,
                                    CASE WHEN IsCustomerSMS = 1 THEN ISNULL(sms_template_body,'') ELSE '' END sms_template_body,
                                    CASE WHEN IsUserEmail = 1 THEN ISNULL(email_subject_user,'') ELSE '' END email_subject_user,
                                    CASE WHEN IsUserEmail = 1 THEN ISNULL(template_body_user,'') ELSE '' END template_body_user,
                                    CASE WHEN IsUserSMS = 1 THEN ISNULL(sms_template_body_user,'') ELSE '' END sms_template_body_user
                                    FROM Queue_Template_Grid a JOIN template_master b ON a.Template_Id = b.template_id WHERE Queue_Id = 8 AND Actions = 'Manual Assign'
06:20:58  @@ 10, , BEGIN TRANSACTION [Tran1]  BEGIN TRY  IF OBJECT_ID('tempdb..#TEMP') IS NOT NULL DROP TABLE #TEMP  IF OBJECT_ID('tempdb..#ConvTemp') IS NOT NULL DROP TABLE #ConvTemp  SELECT ROW_NUMBER() OVER(PARTITION BY ticket_unique_id ORDER BY conversation_id) ROW,conversation_id,email_message_id  ,[subject],ticket_unique_id INTO #ConvTemp  FROM conversation_master a WITH(NOLOCK,INDEX(conversation_master_ticket_unique_id)) JOIN[dbo].[Split] ('11151',',') F ON a.ticket_unique_id = F.Data  DELETE FROM #ConvTemp WHERE ROW !=1  DECLARE @temp as table(conversation_id int)  UPDATE A SET assigned_to=,isassigned=1,assigned_by=0 FROM TICKET_MASTER A JOIN [dbo].[Split]('11151',',') F ON a.ticket_unique_id = F.Data  SELECT b.category_id,b.subcategory_id,GETDATE() date,B.ticket_unique_id,B.ticket_id,Send_Account_Id,email_id,customer_name,b.[from],  ISNULL(e.IsHappyCode,0)IsHappyCode,b.Happy_Code,b.[to],b.CC,c.subject,B.status_id,B.priority_id,B.queue_id,B.phone_no,assigned_to,c.email_message_id Pre_email_message_id INTO #TEMP  FROM Ticket_Master B WITH(NOLOCK)  JOIN #ConvTemp c ON c.ticket_unique_id=b.ticket_unique_id JOIN queue_master E WITH(NOLOCK) ON E.queue_id = B.queue_id  JOIN emailaccount_master G WITH(NOLOCK) ON G.emailaccount_id = E.Send_Account_Id INSERT INTO Conversation_Master(category_id,subcategory_id,SMS_max_try,max_try,Conversation_Date,Conversation_Type,ticket_unique_id,Ticket_Id,Account_Id,[From],[To],Cc,Subject,Status_Id,Priority_Id,Queue_Id,Login_Id,Email_Status,No_Of_Try,email_message_id,sms_conversation,sms_status,SMS_no_of_try,phone_no) OUTPUT Inserted.conversation_id  INTO @temp  SELECT category_id,subcategory_id,0,0,GETDATE(),'Manual Assign Customer',B.ticket_unique_id,B.ticket_id,Send_Account_Id,email_id,B.[from]+ CASE WHEN LEN(REPLACE(REPLACE(REPLACE(REPLACE(b.[to],','+email_id,''),email_id+',',''),','+email_id+',',''),email_id,''))=0 THEN '' ELSE ','+REPLACE(REPLACE(REPLACE(REPLACE(b.[to],','+email_id,''),email_id+',',''),','+email_id+',',''),email_id,'') END ,B.CC,REPLACE( REPLACE( REPLACE( REPLACE( REPLACE('##subject## Ticket Id :- ##ticketid##','##ticketid##',B.ticket_id) ,'##subject##',b.subject) ,'##Mobile##',ISNULL(B.phone_no,'')) ,'##Agent_Name##',ISNULL(c.name,'')) ,'##CustomerName##',ISNULL(b.customer_name,'')),B.status_id,B.priority_id,B.queue_id,0,'NEW',0,REPLACE(NEWID(),'-',''), NULL  ,'none' ,0,B.phone_no FROM #TEMP B  JOIN User_Master c WITH(NOLOCK) ON b.assigned_to=c.user_id  UNION ALL  SELECT category_id,subcategory_id,0,0,GETDATE(),'Manual Assign Agent',B.ticket_unique_id,B.ticket_id,Send_Account_Id,email_id,c.email  ,'',REPLACE( REPLACE( REPLACE( REPLACE( REPLACE('Ticket Id :- ##ticketid##  is Assigned','##ticketid##',B.ticket_id) ,'##subject##',b.subject) ,'##Mobile##',ISNULL(B.phone_no,'')) ,'##Agent_Name##',ISNULL(c.name,'')) ,'##CustomerName##',ISNULL(b.customer_name,'')),B.status_id,B.priority_id,B.queue_id,0,'NEW',0,REPLACE(NEWID(),'-',''),REPLACE( REPLACE( REPLACE( REPLACE( REPLACE('Hi ##Agent_Name##,

Ticket Id :- ##ticketid## is assigned to you.

##remarks##','##ticketid##',B.ticket_id) ,'##subject##',b.subject) ,'##Mobile##',ISNULL(B.phone_no,'')) ,'##Agent_Name##',ISNULL(c.name,'')) ,'##CustomerName##',ISNULL(b.customer_name,'')) ,'NEW' ,0,c.phoneno FROM #TEMP B  JOIN User_Master c WITH(NOLOCK) ON b.assigned_to=c.user_id WHERE ISNULL(c.email,'')!='';  insert into AssignLogs(TicketId,AssignedBy,AssignedTo,LastAssigned,AssignedOn)  SELECT ticket_unique_id , 0,,assigned_to,Getdate() FROM #TEMP ; SELECT a.subject,a.cc,a.[to],a.[from],a.email_message_id,a.conversation_type,  c.Pre_email_message_id,c.ticket_id,c.phone_no,d.name,c.customer_name,d.signature,c.ticket_unique_id  ,c.cc Pri_cc,c.[from] Pri_from,c.[to] Pri_to,c.Happy_Code,ISNULL(c.IsHappyCode,0)IsHappyCode,c.assigned_to,c.email_id  FROM conversation_master a JOIN @temp b ON a.conversation_id=b.conversation_id  JOIN #TEMP c ON c.ticket_unique_id=a.ticket_unique_id  JOIN User_Master d WITH(NOLOCK) ON c.assigned_to=d.user_id  COMMIT TRANSACTION [Tran1]  END TRY  BEGIN CATCH ROLLBACK TRANSACTION[Tran1] END CATCH 
06:21:00  @@ 11, , SELECT TOP 1 (select top 1 status_id from status_master where status='Open')Status_id,a.queue_id,emailaccount_id,email_id,(SELECT TOP 1 category_id FROM category_master WHERE NAME='')Category  from queue_master a JOIN emailaccount_master b ON a.default_account_id=b.emailaccount_id where a.name='test' AND a.isactive=1  
06:21:00  @@ 12, ,select isqueuewiseprefix from company_setup with(nolock)
06:21:00  @@ 13, ,select ticket_prefix from queue_master with(nolock) where queue_id=8
06:21:04  @@ 14, ,SELECT top 1 CASE WHEN IsCustomerEmail = 1 THEN ISNULL(email_subject,'') ELSE '' END email_subject,
                                    CASE WHEN IsCustomerEmail = 1 THEN ISNULL(template_body,'') ELSE '' END template_body,
                                    CASE WHEN IsCustomerSMS = 1 THEN ISNULL(sms_template_body,'') ELSE '' END sms_template_body,
                                    CASE WHEN IsUserEmail = 1 THEN ISNULL(email_subject_user,'') ELSE '' END email_subject_user,
                                    CASE WHEN IsUserEmail = 1 THEN ISNULL(template_body_user,'') ELSE '' END template_body_user,
                                    CASE WHEN IsUserSMS = 1 THEN ISNULL(sms_template_body_user,'') ELSE '' END sms_template_body_user
                                    FROM Queue_Template_Grid a JOIN template_master b ON a.Template_Id = b.template_id WHERE Queue_Id = 8 AND Actions = 'Open'
06:22:24  @@ 15, ,SELECT top 1 CASE WHEN IsCustomerEmail = 1 THEN ISNULL(email_subject,'') ELSE '' END email_subject,
                                    CASE WHEN IsCustomerEmail = 1 THEN ISNULL(template_body,'') ELSE '' END template_body,
                                    CASE WHEN IsCustomerSMS = 1 THEN ISNULL(sms_template_body,'') ELSE '' END sms_template_body,
                                    CASE WHEN IsUserEmail = 1 THEN ISNULL(email_subject_user,'') ELSE '' END email_subject_user,
                                    CASE WHEN IsUserEmail = 1 THEN ISNULL(template_body_user,'') ELSE '' END template_body_user,
                                    CASE WHEN IsUserSMS = 1 THEN ISNULL(sms_template_body_user,'') ELSE '' END sms_template_body_user
                                    FROM Queue_Template_Grid a JOIN template_master b ON a.Template_Id = b.template_id WHERE Queue_Id = 8 AND Actions = 'Open'
06:22:24  @@ 16, ,INSERT INTO Ticket_Master(Happy_Code,subject,ticket_prefix,start_mode,start_date,customer_name,unique_id,phone_no,queue_id,category_id, subcategory_id,[from],[to],cc,bcc,priority_id,status_id,assigned_to,isassigned,assigned_by,assigned_on,ticket_created_by)values( '1359','','TT','On Call',GETDATE(),'', NULL,'9026774169','8', '0',0,'','test@sansoftwares.com',NULL,NULL,NULL,  '3',NULL,NULL,'',GETDATE(),'');SELECT SCOPE_IDENTITY()
06:22:24  @@ 17, ,UPDATE Ticket_Master SET ticket_id='[#TT200808-11152]',subject=' Ticket Id :- [#TT200808-11152]' where ticket_unique_id=11152
06:22:24  @@ 18, ,INSERT INTO conversation_master(conversation_date,conversation_type,ticket_unique_id,ticket_id,phone_no,account_id,[from],[to],cc,bcc,subject,sms_conversation,category_id,subcategory_id,status_id,priority_id,queue_id,login_id,email_status,sms_status,no_of_try,max_try,email_message_id) values(GETDATE(),'On Call','11152','[#TT200808-11152]','9026774169', '5','test@sansoftwares.com','',NULL, NULL,N'',null, '0',NULL, '3',NULL, '8','','none','none',0,0,'510a6d01e8a34bf2a46d84f2469cc456');select SCOPE_IDENTITY(); EXEC DBO.USP_INS_TICKET_LOG '11152','','New Ticket','New ticket generated On call' 
06:22:27  @@ 19, ,select top 1 isnull(IsManual_Assign,0)IsManual_Assign from company_setup 
06:22:27  @@ 20, ,SELECT top 1 CASE WHEN IsCustomerEmail = 1 THEN ISNULL(email_subject,'') ELSE '' END email_subject,
                                    CASE WHEN IsCustomerEmail = 1 THEN ISNULL(template_body,'') ELSE '' END template_body,
                                    CASE WHEN IsCustomerSMS = 1 THEN ISNULL(sms_template_body,'') ELSE '' END sms_template_body,
                                    CASE WHEN IsUserEmail = 1 THEN ISNULL(email_subject_user,'') ELSE '' END email_subject_user,
                                    CASE WHEN IsUserEmail = 1 THEN ISNULL(template_body_user,'') ELSE '' END template_body_user,
                                    CASE WHEN IsUserSMS = 1 THEN ISNULL(sms_template_body_user,'') ELSE '' END sms_template_body_user
                                    FROM Queue_Template_Grid a JOIN template_master b ON a.Template_Id = b.template_id WHERE Queue_Id = 8 AND Actions = 'Manual Assign'
06:22:27  @@ 21, , BEGIN TRANSACTION [Tran1]  BEGIN TRY  IF OBJECT_ID('tempdb..#TEMP') IS NOT NULL DROP TABLE #TEMP  IF OBJECT_ID('tempdb..#ConvTemp') IS NOT NULL DROP TABLE #ConvTemp  SELECT ROW_NUMBER() OVER(PARTITION BY ticket_unique_id ORDER BY conversation_id) ROW,conversation_id,email_message_id  ,[subject],ticket_unique_id INTO #ConvTemp  FROM conversation_master a WITH(NOLOCK,INDEX(conversation_master_ticket_unique_id)) JOIN[dbo].[Split] ('11152',',') F ON a.ticket_unique_id = F.Data  DELETE FROM #ConvTemp WHERE ROW !=1  DECLARE @temp as table(conversation_id int)  UPDATE A SET assigned_to=,isassigned=1,assigned_by=0 FROM TICKET_MASTER A JOIN [dbo].[Split]('11152',',') F ON a.ticket_unique_id = F.Data  SELECT b.category_id,b.subcategory_id,GETDATE() date,B.ticket_unique_id,B.ticket_id,Send_Account_Id,email_id,customer_name,b.[from],  ISNULL(e.IsHappyCode,0)IsHappyCode,b.Happy_Code,b.[to],b.CC,c.subject,B.status_id,B.priority_id,B.queue_id,B.phone_no,assigned_to,c.email_message_id Pre_email_message_id INTO #TEMP  FROM Ticket_Master B WITH(NOLOCK)  JOIN #ConvTemp c ON c.ticket_unique_id=b.ticket_unique_id JOIN queue_master E WITH(NOLOCK) ON E.queue_id = B.queue_id  JOIN emailaccount_master G WITH(NOLOCK) ON G.emailaccount_id = E.Send_Account_Id INSERT INTO Conversation_Master(category_id,subcategory_id,SMS_max_try,max_try,Conversation_Date,Conversation_Type,ticket_unique_id,Ticket_Id,Account_Id,[From],[To],Cc,Subject,Status_Id,Priority_Id,Queue_Id,Login_Id,Email_Status,No_Of_Try,email_message_id,sms_conversation,sms_status,SMS_no_of_try,phone_no) OUTPUT Inserted.conversation_id  INTO @temp  SELECT category_id,subcategory_id,0,0,GETDATE(),'Manual Assign Customer',B.ticket_unique_id,B.ticket_id,Send_Account_Id,email_id,B.[from]+ CASE WHEN LEN(REPLACE(REPLACE(REPLACE(REPLACE(b.[to],','+email_id,''),email_id+',',''),','+email_id+',',''),email_id,''))=0 THEN '' ELSE ','+REPLACE(REPLACE(REPLACE(REPLACE(b.[to],','+email_id,''),email_id+',',''),','+email_id+',',''),email_id,'') END ,B.CC,REPLACE( REPLACE( REPLACE( REPLACE( REPLACE('##subject## Ticket Id :- ##ticketid##','##ticketid##',B.ticket_id) ,'##subject##',b.subject) ,'##Mobile##',ISNULL(B.phone_no,'')) ,'##Agent_Name##',ISNULL(c.name,'')) ,'##CustomerName##',ISNULL(b.customer_name,'')),B.status_id,B.priority_id,B.queue_id,0,'NEW',0,REPLACE(NEWID(),'-',''), NULL  ,'none' ,0,B.phone_no FROM #TEMP B  JOIN User_Master c WITH(NOLOCK) ON b.assigned_to=c.user_id  UNION ALL  SELECT category_id,subcategory_id,0,0,GETDATE(),'Manual Assign Agent',B.ticket_unique_id,B.ticket_id,Send_Account_Id,email_id,c.email  ,'',REPLACE( REPLACE( REPLACE( REPLACE( REPLACE('Ticket Id :- ##ticketid##  is Assigned','##ticketid##',B.ticket_id) ,'##subject##',b.subject) ,'##Mobile##',ISNULL(B.phone_no,'')) ,'##Agent_Name##',ISNULL(c.name,'')) ,'##CustomerName##',ISNULL(b.customer_name,'')),B.status_id,B.priority_id,B.queue_id,0,'NEW',0,REPLACE(NEWID(),'-',''),REPLACE( REPLACE( REPLACE( REPLACE( REPLACE('Hi ##Agent_Name##,

Ticket Id :- ##ticketid## is assigned to you.

##remarks##','##ticketid##',B.ticket_id) ,'##subject##',b.subject) ,'##Mobile##',ISNULL(B.phone_no,'')) ,'##Agent_Name##',ISNULL(c.name,'')) ,'##CustomerName##',ISNULL(b.customer_name,'')) ,'NEW' ,0,c.phoneno FROM #TEMP B  JOIN User_Master c WITH(NOLOCK) ON b.assigned_to=c.user_id WHERE ISNULL(c.email,'')!='';  insert into AssignLogs(TicketId,AssignedBy,AssignedTo,LastAssigned,AssignedOn)  SELECT ticket_unique_id , 0,,assigned_to,Getdate() FROM #TEMP ; SELECT a.subject,a.cc,a.[to],a.[from],a.email_message_id,a.conversation_type,  c.Pre_email_message_id,c.ticket_id,c.phone_no,d.name,c.customer_name,d.signature,c.ticket_unique_id  ,c.cc Pri_cc,c.[from] Pri_from,c.[to] Pri_to,c.Happy_Code,ISNULL(c.IsHappyCode,0)IsHappyCode,c.assigned_to,c.email_id  FROM conversation_master a JOIN @temp b ON a.conversation_id=b.conversation_id  JOIN #TEMP c ON c.ticket_unique_id=a.ticket_unique_id  JOIN User_Master d WITH(NOLOCK) ON c.assigned_to=d.user_id  COMMIT TRANSACTION [Tran1]  END TRY  BEGIN CATCH ROLLBACK TRANSACTION[Tran1] END CATCH 
06:22:57  @@ 60, , SELECT TOP 1 (select top 1 status_id from status_master where status='Open')Status_id,a.queue_id,emailaccount_id,email_id,(SELECT TOP 1 category_id FROM category_master WHERE NAME='')Category  from queue_master a JOIN emailaccount_master b ON a.default_account_id=b.emailaccount_id where a.name='test' AND a.isactive=1  
06:22:57  @@ 61, ,select isqueuewiseprefix from company_setup with(nolock)
06:22:57  @@ 62, ,select ticket_prefix from queue_master with(nolock) where queue_id=8
06:22:58  @@ 63, ,SELECT top 1 CASE WHEN IsCustomerEmail = 1 THEN ISNULL(email_subject,'') ELSE '' END email_subject,
                                    CASE WHEN IsCustomerEmail = 1 THEN ISNULL(template_body,'') ELSE '' END template_body,
                                    CASE WHEN IsCustomerSMS = 1 THEN ISNULL(sms_template_body,'') ELSE '' END sms_template_body,
                                    CASE WHEN IsUserEmail = 1 THEN ISNULL(email_subject_user,'') ELSE '' END email_subject_user,
                                    CASE WHEN IsUserEmail = 1 THEN ISNULL(template_body_user,'') ELSE '' END template_body_user,
                                    CASE WHEN IsUserSMS = 1 THEN ISNULL(sms_template_body_user,'') ELSE '' END sms_template_body_user
                                    FROM Queue_Template_Grid a JOIN template_master b ON a.Template_Id = b.template_id WHERE Queue_Id = 8 AND Actions = 'Open'
06:23:00  @@ 64, ,INSERT INTO Ticket_Master(Happy_Code,subject,ticket_prefix,start_mode,start_date,customer_name,unique_id,phone_no,queue_id,category_id, subcategory_id,[from],[to],cc,bcc,priority_id,status_id,assigned_to,isassigned,assigned_by,assigned_on,ticket_created_by)values( '1915','','TT','On Call',GETDATE(),'', NULL,'9026774169','8', '0',0,'','test@sansoftwares.com',NULL,NULL,NULL,  '3',NULL,NULL,'',GETDATE(),'');SELECT SCOPE_IDENTITY()
06:23:02  @@ 65, ,UPDATE Ticket_Master SET ticket_id='[#TT200808-11153]',subject=' Ticket Id :- [#TT200808-11153]' where ticket_unique_id=11153
06:23:03  @@ 66, ,INSERT INTO conversation_master(conversation_date,conversation_type,ticket_unique_id,ticket_id,phone_no,account_id,[from],[to],cc,bcc,subject,sms_conversation,category_id,subcategory_id,status_id,priority_id,queue_id,login_id,email_status,sms_status,no_of_try,max_try,email_message_id) values(GETDATE(),'On Call','11153','[#TT200808-11153]','9026774169', '5','test@sansoftwares.com','',NULL, NULL,N'',null, '0',NULL, '3',NULL, '8','','none','none',0,0,'7e02e19c1e09474092cc72a32c83f12e');select SCOPE_IDENTITY(); EXEC DBO.USP_INS_TICKET_LOG '11153','','New Ticket','New ticket generated On call' 
06:23:38  @@ 67, ,INSERT INTO conversation_master(conversation_date,conversation_type,ticket_unique_id,ticket_id,phone_no,account_id,[from],[to],cc,bcc,subject,sms_conversation,category_id,subcategory_id,status_id,priority_id,queue_id,login_id,email_status,sms_status,no_of_try,max_try,email_message_id) values(GETDATE(),'Auto Reply Email','11153','[#TT200808-11153]','9026774169', '5','test@sansoftwares.com','',NULL, NULL,N' Ticket Id :- [#TT200808-11153]',N'Dear Sender,

Thank you for reaching out. Your ticket has been created with the ticket ID [#TT200808-11153] and subject &quot;&quot;
your HappyCode is - 1915
', '0',NULL, '3',NULL, '8','','none','NEW',0,0,'38c827a0e5ab4fadb281824f4216ae2d');select SCOPE_IDENTITY(); EXEC DBO.USP_INS_TICKET_LOG '11153','','Manual Reply','Auto Reply Manual' 
06:23:42  @@ 68, ,select top 1 isnull(IsManual_Assign,0)IsManual_Assign from company_setup 
06:23:43  @@ 69, ,SELECT top 1 CASE WHEN IsCustomerEmail = 1 THEN ISNULL(email_subject,'') ELSE '' END email_subject,
                                    CASE WHEN IsCustomerEmail = 1 THEN ISNULL(template_body,'') ELSE '' END template_body,
                                    CASE WHEN IsCustomerSMS = 1 THEN ISNULL(sms_template_body,'') ELSE '' END sms_template_body,
                                    CASE WHEN IsUserEmail = 1 THEN ISNULL(email_subject_user,'') ELSE '' END email_subject_user,
                                    CASE WHEN IsUserEmail = 1 THEN ISNULL(template_body_user,'') ELSE '' END template_body_user,
                                    CASE WHEN IsUserSMS = 1 THEN ISNULL(sms_template_body_user,'') ELSE '' END sms_template_body_user
                                    FROM Queue_Template_Grid a JOIN template_master b ON a.Template_Id = b.template_id WHERE Queue_Id = 8 AND Actions = 'Manual Assign'
06:24:37  @@ 70, , BEGIN TRANSACTION [Tran1]  BEGIN TRY  IF OBJECT_ID('tempdb..#TEMP') IS NOT NULL DROP TABLE #TEMP  IF OBJECT_ID('tempdb..#ConvTemp') IS NOT NULL DROP TABLE #ConvTemp  SELECT ROW_NUMBER() OVER(PARTITION BY ticket_unique_id ORDER BY conversation_id) ROW,conversation_id,email_message_id  ,[subject],ticket_unique_id INTO #ConvTemp  FROM conversation_master a WITH(NOLOCK,INDEX(conversation_master_ticket_unique_id)) JOIN[dbo].[Split] ('11153',',') F ON a.ticket_unique_id = F.Data  DELETE FROM #ConvTemp WHERE ROW !=1  DECLARE @temp as table(conversation_id int)  UPDATE A SET assigned_to=,isassigned=1,assigned_by=0 FROM TICKET_MASTER A JOIN [dbo].[Split]('11153',',') F ON a.ticket_unique_id = F.Data  SELECT b.category_id,b.subcategory_id,GETDATE() date,B.ticket_unique_id,B.ticket_id,Send_Account_Id,email_id,customer_name,b.[from],  ISNULL(e.IsHappyCode,0)IsHappyCode,b.Happy_Code,b.[to],b.CC,c.subject,B.status_id,B.priority_id,B.queue_id,B.phone_no,assigned_to,c.email_message_id Pre_email_message_id INTO #TEMP  FROM Ticket_Master B WITH(NOLOCK)  JOIN #ConvTemp c ON c.ticket_unique_id=b.ticket_unique_id JOIN queue_master E WITH(NOLOCK) ON E.queue_id = B.queue_id  JOIN emailaccount_master G WITH(NOLOCK) ON G.emailaccount_id = E.Send_Account_Id INSERT INTO Conversation_Master(category_id,subcategory_id,SMS_max_try,max_try,Conversation_Date,Conversation_Type,ticket_unique_id,Ticket_Id,Account_Id,[From],[To],Cc,Subject,Status_Id,Priority_Id,Queue_Id,Login_Id,Email_Status,No_Of_Try,email_message_id,sms_conversation,sms_status,SMS_no_of_try,phone_no) OUTPUT Inserted.conversation_id  INTO @temp  SELECT category_id,subcategory_id,0,0,GETDATE(),'Manual Assign Customer',B.ticket_unique_id,B.ticket_id,Send_Account_Id,email_id,B.[from]+ CASE WHEN LEN(REPLACE(REPLACE(REPLACE(REPLACE(b.[to],','+email_id,''),email_id+',',''),','+email_id+',',''),email_id,''))=0 THEN '' ELSE ','+REPLACE(REPLACE(REPLACE(REPLACE(b.[to],','+email_id,''),email_id+',',''),','+email_id+',',''),email_id,'') END ,B.CC,REPLACE( REPLACE( REPLACE( REPLACE( REPLACE('##subject## Ticket Id :- ##ticketid##','##ticketid##',B.ticket_id) ,'##subject##',b.subject) ,'##Mobile##',ISNULL(B.phone_no,'')) ,'##Agent_Name##',ISNULL(c.name,'')) ,'##CustomerName##',ISNULL(b.customer_name,'')),B.status_id,B.priority_id,B.queue_id,0,'NEW',0,REPLACE(NEWID(),'-',''), NULL  ,'none' ,0,B.phone_no FROM #TEMP B  JOIN User_Master c WITH(NOLOCK) ON b.assigned_to=c.user_id  UNION ALL  SELECT category_id,subcategory_id,0,0,GETDATE(),'Manual Assign Agent',B.ticket_unique_id,B.ticket_id,Send_Account_Id,email_id,c.email  ,'',REPLACE( REPLACE( REPLACE( REPLACE( REPLACE('Ticket Id :- ##ticketid##  is Assigned','##ticketid##',B.ticket_id) ,'##subject##',b.subject) ,'##Mobile##',ISNULL(B.phone_no,'')) ,'##Agent_Name##',ISNULL(c.name,'')) ,'##CustomerName##',ISNULL(b.customer_name,'')),B.status_id,B.priority_id,B.queue_id,0,'NEW',0,REPLACE(NEWID(),'-',''),REPLACE( REPLACE( REPLACE( REPLACE( REPLACE('Hi ##Agent_Name##,

Ticket Id :- ##ticketid## is assigned to you.

##remarks##','##ticketid##',B.ticket_id) ,'##subject##',b.subject) ,'##Mobile##',ISNULL(B.phone_no,'')) ,'##Agent_Name##',ISNULL(c.name,'')) ,'##CustomerName##',ISNULL(b.customer_name,'')) ,'NEW' ,0,c.phoneno FROM #TEMP B  JOIN User_Master c WITH(NOLOCK) ON b.assigned_to=c.user_id WHERE ISNULL(c.email,'')!='';  insert into AssignLogs(TicketId,AssignedBy,AssignedTo,LastAssigned,AssignedOn)  SELECT ticket_unique_id , 0,,assigned_to,Getdate() FROM #TEMP ; SELECT a.subject,a.cc,a.[to],a.[from],a.email_message_id,a.conversation_type,  c.Pre_email_message_id,c.ticket_id,c.phone_no,d.name,c.customer_name,d.signature,c.ticket_unique_id  ,c.cc Pri_cc,c.[from] Pri_from,c.[to] Pri_to,c.Happy_Code,ISNULL(c.IsHappyCode,0)IsHappyCode,c.assigned_to,c.email_id  FROM conversation_master a JOIN @temp b ON a.conversation_id=b.conversation_id  JOIN #TEMP c ON c.ticket_unique_id=a.ticket_unique_id  JOIN User_Master d WITH(NOLOCK) ON c.assigned_to=d.user_id  COMMIT TRANSACTION [Tran1]  END TRY  BEGIN CATCH ROLLBACK TRANSACTION[Tran1] END CATCH 
06:33:55  @@ 87, , SELECT TOP 1 (select top 1 status_id from status_master where status='Open')Status_id,a.queue_id,emailaccount_id,email_id,(SELECT TOP 1 category_id FROM category_master WHERE NAME='')Category  from queue_master a JOIN emailaccount_master b ON a.default_account_id=b.emailaccount_id where a.name='test' AND a.isactive=1  
06:33:55  @@ 88, ,select isqueuewiseprefix from company_setup with(nolock)
06:33:55  @@ 89, ,select ticket_prefix from queue_master with(nolock) where queue_id=8
06:33:55  @@ 90, ,SELECT top 1 CASE WHEN IsCustomerEmail = 1 THEN ISNULL(email_subject,'') ELSE '' END email_subject,
                                    CASE WHEN IsCustomerEmail = 1 THEN ISNULL(template_body,'') ELSE '' END template_body,
                                    CASE WHEN IsCustomerSMS = 1 THEN ISNULL(sms_template_body,'') ELSE '' END sms_template_body,
                                    CASE WHEN IsUserEmail = 1 THEN ISNULL(email_subject_user,'') ELSE '' END email_subject_user,
                                    CASE WHEN IsUserEmail = 1 THEN ISNULL(template_body_user,'') ELSE '' END template_body_user,
                                    CASE WHEN IsUserSMS = 1 THEN ISNULL(sms_template_body_user,'') ELSE '' END sms_template_body_user
                                    FROM Queue_Template_Grid a JOIN template_master b ON a.Template_Id = b.template_id WHERE Queue_Id = 8 AND Actions = 'Open'
06:33:55  @@ 91, ,INSERT INTO Ticket_Master(Happy_Code,subject,ticket_prefix,start_mode,start_date,customer_name,unique_id,phone_no,queue_id,category_id, subcategory_id,[from],[to],cc,bcc,priority_id,status_id,assigned_to,isassigned,assigned_by,assigned_on,ticket_created_by)values( '1472','','TT','On Call',GETDATE(),'', NULL,'9026774169','8', '0',0,'','test@sansoftwares.com',NULL,NULL,NULL,  '3',NULL,NULL,'',GETDATE(),'');SELECT SCOPE_IDENTITY()
06:33:55  @@ 92, ,UPDATE Ticket_Master SET ticket_id='[#TT200808-11154]',subject=' Ticket Id :- [#TT200808-11154]' where ticket_unique_id=11154
06:33:55  @@ 93, ,INSERT INTO conversation_master(conversation_date,conversation_type,ticket_unique_id,ticket_id,phone_no,account_id,[from],[to],cc,bcc,subject,sms_conversation,category_id,subcategory_id,status_id,priority_id,queue_id,login_id,email_status,sms_status,no_of_try,max_try,email_message_id) values(GETDATE(),'On Call','11154','[#TT200808-11154]','9026774169', '5','test@sansoftwares.com','',NULL, NULL,N'',null, '0',NULL, '3',NULL, '8','','none','none',0,0,'834b424414a5498487a9d7c627bf350f');select SCOPE_IDENTITY(); EXEC DBO.USP_INS_TICKET_LOG '11154','','New Ticket','New ticket generated On call' 
06:33:55  @@ 94, ,INSERT INTO conversation_master(conversation_date,conversation_type,ticket_unique_id,ticket_id,phone_no,account_id,[from],[to],cc,bcc,subject,sms_conversation,category_id,subcategory_id,status_id,priority_id,queue_id,login_id,email_status,sms_status,no_of_try,max_try,email_message_id) values(GETDATE(),'Auto Reply Email','11154','[#TT200808-11154]','9026774169', '5','test@sansoftwares.com','',NULL, NULL,N' Ticket Id :- [#TT200808-11154]',N'Dear Sender,

Thank you for reaching out. Your ticket has been created with the ticket ID [#TT200808-11154] and subject &quot;&quot;
your HappyCode is - 1472
', '0',NULL, '3',NULL, '8','','none','NEW',0,0,'03e459cadfcc4a1da48eb78d0c62ffda');select SCOPE_IDENTITY(); EXEC DBO.USP_INS_TICKET_LOG '11154','','Manual Reply','Auto Reply Manual' 
06:50:34  @@ 95, ,select count(Phone_No) from Ticket_Master where Phone_No='9026774169'
06:50:34  @@ 96, ,select Ticket_Id,SM.status [Status],UM.name [AssignedTo],FORMAT(start_date,'d/M/yyyy h:m:s tt')[CreatedDate] 
                            from Ticket_Master TM 
                            Left join status_master SM on TM.status_id=SM.status_id
                            Left join user_Master UM on TM.assigned_to=UM.user_id 
                            where SM.status in('open','pending') and isnull(phone_no,'')='9026774169'
06:51:15  @@ 97, ,select count(Phone_No) from Ticket_Master where Phone_No='9026774169'
06:51:15  @@ 98, ,select Ticket_Id,SM.status [Status],UM.name [AssignedTo],FORMAT(start_date,'d/M/yyyy h:m:s tt')[CreatedDate] 
                            from Ticket_Master TM 
                            Left join status_master SM on TM.status_id=SM.status_id
                            Left join user_Master UM on TM.assigned_to=UM.user_id 
                            where SM.status in('open','pending') and isnull(phone_no,'')='9026774169'
07:03:23  @@ 99, ,select count(Phone_No) from Ticket_Master where Phone_No='9026774169'
07:03:23  @@ 100, ,select top 1 FORMAT(start_date,'yyMMdd')+'-'+substring(Ticket_Id,charindex('-',Ticket_Id)+1,LEN(Ticket_Id)-charindex('-',Ticket_Id)-1)Ticket_Id,SM.status [Status],isnull(UM.name,'') [AssignedTo],FORMAT(start_date,'d/M/yyyy')[CreatedDate] 
                            from Ticket_Master TM 
                            Left join status_master SM on TM.status_id=SM.status_id
                            Left join user_Master UM on TM.assigned_to=UM.user_id 
                            where SM.status in('open','pending') and isnull(phone_no,'')='9026774169' order by start_date desc
