I have a table called Employee which has 2 column say FromDateFromDate
and ToDateToDate
, both are of type nvarchar(max) nvarchar(max)
. Now iI am getting input like this [[09:00 AM-11:00 AM],[02:00PM-03:00PM] i [[09:00 AM-11:00 AM],[02:00PM-03:00PM]
. I have to insert each value in the fromdatefromdate
and to datetodate
like below
Fromdate ToDate
09:00AM 11:00 AM
02:00PM 03:00PM
Fromdate ToDate
09:00AM 11:00 AM
02:00PM 03:00PM
How to do in sqlan SQL procedure or querystatement?