11:51:29  @@ 1, , SELECT TOP 1 (select top 1 status_id from status_master where status='Open')Status_id,c.user_id, a.queue_id,c.phoneno,c.email,emailaccount_id,email_id,Category from queue_master a JOIN emailaccount_master b ON a.default_account_id=b.emailaccount_id JOIN queuerights_master d ON d.queue_id = a.queue_id JOIN user_master c ON c.user_id = d.user_id where a.name=''  AND d.queue_view=1 AND a.isactive=1 AND c.active=1 ORDER BY coalesce(c.Ticket_Assigned,0) ASC,c.email desc 
11:51:35  @@ 2, , SELECT TOP 1 (select top 1 status_id from status_master where status='Open')Status_id,c.user_id, a.queue_id,c.phoneno,c.email,emailaccount_id,email_id,Category from queue_master a JOIN emailaccount_master b ON a.default_account_id=b.emailaccount_id JOIN queuerights_master d ON d.queue_id = a.queue_id JOIN user_master c ON c.user_id = d.user_id where a.name=''  AND d.queue_view=1 AND a.isactive=1 AND c.active=1 ORDER BY coalesce(c.Ticket_Assigned,0) ASC,c.email desc 
11:51:45  @@ 3, , SELECT TOP 1 (select top 1 status_id from status_master where status='Open')Status_id,c.user_id, a.queue_id,c.phoneno,c.email,emailaccount_id,email_id,Category from queue_master a JOIN emailaccount_master b ON a.default_account_id=b.emailaccount_id JOIN queuerights_master d ON d.queue_id = a.queue_id JOIN user_master c ON c.user_id = d.user_id where a.name=''  AND d.queue_view=1 AND a.isactive=1 AND c.active=1 ORDER BY coalesce(c.Ticket_Assigned,0) ASC,c.email desc 
11:55:02  @@ 4, , SELECT TOP 1 (select top 1 status_id from status_master where status='Open')Status_id,c.user_id, a.queue_id,c.phoneno,c.email,emailaccount_id,email_id,Category from queue_master a JOIN emailaccount_master b ON a.default_account_id=b.emailaccount_id JOIN queuerights_master d ON d.queue_id = a.queue_id JOIN user_master c ON c.user_id = d.user_id where a.name='Support'  AND d.queue_view=1 AND a.isactive=1 AND c.active=1 ORDER BY coalesce(c.Ticket_Assigned,0) ASC,c.email desc 
11:57:05  @@ 5, , SELECT TOP 1 (select top 1 status_id from status_master where status='Open')Status_id,c.user_id, a.queue_id,c.phoneno,c.email,emailaccount_id,email_id,Category from queue_master a JOIN emailaccount_master b ON a.default_account_id=b.emailaccount_id JOIN queuerights_master d ON d.queue_id = a.queue_id JOIN user_master c ON c.user_id = d.user_id where a.name='Support'  AND d.queue_view=1 AND a.isactive=1 AND c.active=1 ORDER BY coalesce(c.Ticket_Assigned,0) ASC,c.email desc 
12:04:00  @@ 6, , 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='Support')Category  from queue_master a JOIN emailaccount_master b ON a.default_account_id=b.emailaccount_id where a.name='Support' AND a.isactive=1  
12:04:33  @@ 7, , 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='Support')Category  from queue_master a JOIN emailaccount_master b ON a.default_account_id=b.emailaccount_id where a.name='Support' AND a.isactive=1  
12:04:42  @@ 8, , 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='Support')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  
12:04:51  @@ 9, ,SEELCT TOP 1 FROM phoneno USER_MASTER WHERE USER_ID='1'
12:05:15  @@ 10, , 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='Support')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  
12:05:17  @@ 11, ,SEELCT TOP 1 phoneno FROM USER_MASTER WHERE USER_ID='1'
12:05:57  @@ 12, , 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='Support')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  
12:05:59  @@ 13, ,SELECT TOP 1 phoneno FROM USER_MASTER WHERE USER_ID='1'
12:06:02  @@ 14, ,select isqueuewiseprefix from company_setup with(nolock)
12:06:03  @@ 15, ,select ticket_prefix from queue_master with(nolock) where queue_id=8
12:06:12  @@ 16, ,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'
12:06:23  @@ 17, ,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( '2048','sub.','TT','On Call',GETDATE(),'ashish', NULL,'9026774169','8', '1',0,'','test@sansoftwares.com',NULL,NULL,NULL,  '3',NULL,NULL,'1',GETDATE(),'1');SELECT SCOPE_IDENTITY()
12:06:27  @@ 18, ,UPDATE Ticket_Master SET ticket_id='[#TT200714-9139]',subject='sub. Ticket Id :- [#TT200714-9139]' where ticket_unique_id=9139
12:06:28  @@ 19, ,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','9139','[#TT200714-9139]','9026774169', '5','test@sansoftwares.com','',NULL, NULL,N'sub.',null, '1',NULL, '3',NULL, '8','1','none','none',0,0,'330d0255324742c8b426dd1e255f0ba1');select SCOPE_IDENTITY(); EXEC DBO.USP_INS_TICKET_LOG '9139','1','New Ticket','New ticket generated On call' 
12:06:39  @@ 20, ,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','9139','[#TT200714-9139]','9026774169', '5','test@sansoftwares.com','',NULL, NULL,N'sub. Ticket Id :- [#TT200714-9139]',N'', '1',NULL, '3',NULL, '8','1','NEW','',0,0,'f45c9f66968c4055b41be7f87a81fc4c');select SCOPE_IDENTITY(); EXEC DBO.USP_INS_TICKET_LOG '9139','1','Manual Reply','Auto Reply Manual' 
12:09:45  @@ 21, , 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='Support')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  
12:09:45  @@ 22, ,SELECT TOP 1 phoneno FROM USER_MASTER WHERE USER_ID='1'
12:09:45  @@ 23, ,select isqueuewiseprefix from company_setup with(nolock)
12:09:45  @@ 24, ,select ticket_prefix from queue_master with(nolock) where queue_id=8
12:09:45  @@ 25, ,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'
12:09:45  @@ 26, ,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( '3857','sub.','TT','On Call',GETDATE(),'ashish', NULL,'9026774169','8', '1',0,'','test@sansoftwares.com',NULL,NULL,NULL,  '3',NULL,NULL,'1',GETDATE(),'1');SELECT SCOPE_IDENTITY()
12:09:45  @@ 27, ,UPDATE Ticket_Master SET ticket_id='[#TT200714-9140]',subject='sub. Ticket Id :- [#TT200714-9140]' where ticket_unique_id=9140
12:09:45  @@ 28, ,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','9140','[#TT200714-9140]','9026774169', '5','test@sansoftwares.com','',NULL, NULL,N'sub.',null, '1',NULL, '3',NULL, '8','1','none','none',0,0,'17dc98476e614055b57831f5d8546395');select SCOPE_IDENTITY(); EXEC DBO.USP_INS_TICKET_LOG '9140','1','New Ticket','New ticket generated On call' 
12:09:45  @@ 29, ,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','9140','[#TT200714-9140]','9026774169', '5','test@sansoftwares.com','',NULL, NULL,N'sub. Ticket Id :- [#TT200714-9140]',N'', '1',NULL, '3',NULL, '8','1','NEW','',0,0,'f01b2935025d439a9d8eda6214086173');select SCOPE_IDENTITY(); EXEC DBO.USP_INS_TICKET_LOG '9140','1','Manual Reply','Auto Reply Manual' 
12:17:22  @@ 30, , 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='Support')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  
12:17:22  @@ 31, ,SELECT TOP 1 phoneno FROM USER_MASTER WHERE USER_ID='1'
12:17:22  @@ 32, ,select isqueuewiseprefix from company_setup with(nolock)
12:17:22  @@ 33, ,select ticket_prefix from queue_master with(nolock) where queue_id=8
12:17:22  @@ 34, ,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'
12:17:22  @@ 35, ,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( '1563','sub.','TT','On Call',GETDATE(),'ashish', NULL,'9026774169','8', '1',0,'','test@sansoftwares.com',NULL,NULL,NULL,  '3',NULL,NULL,'1',GETDATE(),'1');SELECT SCOPE_IDENTITY()
12:17:22  @@ 36, ,UPDATE Ticket_Master SET ticket_id='[#TT200714-9141]',subject='sub. Ticket Id :- [#TT200714-9141]' where ticket_unique_id=9141
12:17:22  @@ 37, ,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','9141','[#TT200714-9141]','9026774169', '5','test@sansoftwares.com','',NULL, NULL,N'sub.',null, '1',NULL, '3',NULL, '8','1','none','none',0,0,'d963f1e666404b5aa5f5e69f21ea50ce');select SCOPE_IDENTITY(); EXEC DBO.USP_INS_TICKET_LOG '9141','1','New Ticket','New ticket generated On call' 
12:17:22  @@ 38, ,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','9141','[#TT200714-9141]','9026774169', '5','test@sansoftwares.com','',NULL, NULL,N'sub. Ticket Id :- [#TT200714-9141]',N'', '1',NULL, '3',NULL, '8','1','NEW','',0,0,'24400480d3e04a7286f30fc70e9a4ada');select SCOPE_IDENTITY(); EXEC DBO.USP_INS_TICKET_LOG '9141','1','Manual Reply','Auto Reply Manual' 
12:17:24  @@ 39, , 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='Support')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  
12:17:24  @@ 40, ,SELECT TOP 1 phoneno FROM USER_MASTER WHERE USER_ID='1'
12:17:24  @@ 41, ,select isqueuewiseprefix from company_setup with(nolock)
12:17:24  @@ 42, ,select ticket_prefix from queue_master with(nolock) where queue_id=8
12:17:24  @@ 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 = 'Open'
12:17:24  @@ 44, ,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( '1160','sub.','TT','On Call',GETDATE(),'ashish', NULL,'9026774169','8', '1',0,'','test@sansoftwares.com',NULL,NULL,NULL,  '3',NULL,NULL,'1',GETDATE(),'1');SELECT SCOPE_IDENTITY()
12:17:24  @@ 45, ,UPDATE Ticket_Master SET ticket_id='[#TT200714-9142]',subject='sub. Ticket Id :- [#TT200714-9142]' where ticket_unique_id=9142
12:17:24  @@ 46, ,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','9142','[#TT200714-9142]','9026774169', '5','test@sansoftwares.com','',NULL, NULL,N'sub.',null, '1',NULL, '3',NULL, '8','1','none','none',0,0,'e40c7d32db3e43338ac9f221a4cdcbd2');select SCOPE_IDENTITY(); EXEC DBO.USP_INS_TICKET_LOG '9142','1','New Ticket','New ticket generated On call' 
12:17:24  @@ 47, ,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','9142','[#TT200714-9142]','9026774169', '5','test@sansoftwares.com','',NULL, NULL,N'sub. Ticket Id :- [#TT200714-9142]',N'', '1',NULL, '3',NULL, '8','1','NEW','',0,0,'3c79764feb144ab3957d15e2229995f5');select SCOPE_IDENTITY(); EXEC DBO.USP_INS_TICKET_LOG '9142','1','Manual Reply','Auto Reply Manual' 
12:17:26  @@ 48, , 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='Support')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  
12:17:26  @@ 49, ,SELECT TOP 1 phoneno FROM USER_MASTER WHERE USER_ID='1'
12:17:26  @@ 50, ,select isqueuewiseprefix from company_setup with(nolock)
12:17:26  @@ 51, ,select ticket_prefix from queue_master with(nolock) where queue_id=8
12:17:26  @@ 52, ,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'
12:17:26  @@ 53, ,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( '2036','sub.','TT','On Call',GETDATE(),'ashish', NULL,'9026774169','8', '1',0,'','test@sansoftwares.com',NULL,NULL,NULL,  '3',NULL,NULL,'1',GETDATE(),'1');SELECT SCOPE_IDENTITY()
12:17:26  @@ 54, ,UPDATE Ticket_Master SET ticket_id='[#TT200714-9143]',subject='sub. Ticket Id :- [#TT200714-9143]' where ticket_unique_id=9143
12:17:26  @@ 55, ,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','9143','[#TT200714-9143]','9026774169', '5','test@sansoftwares.com','',NULL, NULL,N'sub.',null, '1',NULL, '3',NULL, '8','1','none','none',0,0,'2928c150de6a40ad9876bbf184d2b3cd');select SCOPE_IDENTITY(); EXEC DBO.USP_INS_TICKET_LOG '9143','1','New Ticket','New ticket generated On call' 
12:17:26  @@ 56, ,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','9143','[#TT200714-9143]','9026774169', '5','test@sansoftwares.com','',NULL, NULL,N'sub. Ticket Id :- [#TT200714-9143]',N'', '1',NULL, '3',NULL, '8','1','NEW','',0,0,'f15b17ce991341f09bf1cea9bb7ddfa3');select SCOPE_IDENTITY(); EXEC DBO.USP_INS_TICKET_LOG '9143','1','Manual Reply','Auto Reply Manual' 
