How to extract dates from a string type column and load into 2 different datetime columns in SQL server?
I do have a ms sql server db table like below
Create table #src (ID int,Descr varchar(500))
Insert into #src (ID,Descr) values (1,’Test abc – May 2022 to April 2023′)
Insert into #src (ID,Descr) values (2,’abc – Apr 2020 to March 2021′)
Insert into #src (ID,Descr) values (3,’dyx – May 2023 to April 2024′)
Select * from #src