great, Perfect Thanks!, it worked , Thanks Chris 🙂

Added expected result column, please let me know if any questions, Thanks.

It worked, Thank you guys! Awesome!

Good question, DAN25 and V99 id of the person, some cases it is appended with name and some cases its not updated. As of now don't have other formats, if...

Code looks awesome, Thank you so much for your help! Much appreciated. I'm have started validation so far looks good, I will let you know if any questions! thanks for...

I have modified, please check it once,sorry can't test

create table dbo.Master_Data
(
Ticket_Num Bigint,
Title varchar(100),
Schedue_time varchar(500)
)

Insert into dbo.Master_Data (Ticket_Num,Title,Schedue_time...

Sorry, I left system in office and prepared code from mobile 03 is month and 13th is date, so 13th march 2017

Hi, Please find the DDL, let me know if any questions, thank you.

create table dbo.Master_Data
( 
Ticket_Num Bigint,
Title varchar(100),
Schedue_time varchar(500)
)

Insert into...