Skip to main content
added 35 characters in body
Source Link
mustaccio
  • 26.9k
  • 24
  • 58
  • 74

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?

I have a table called Employee which has 2 column say FromDate and ToDate both are of type nvarchar(max). Now i am getting input like this [[09:00 AM-11:00 AM],[02:00PM-03:00PM] i have to insert each value in the fromdate and to date like below Fromdate ToDate 09:00AM 11:00 AM 02:00PM 03:00PM

How to do in sql procedure or query

I have a table called Employee which has 2 column say FromDate and ToDate, both are of type nvarchar(max). Now I am getting input like this [[09:00 AM-11:00 AM],[02:00PM-03:00PM]. I have to insert each value in the fromdate and todate like below

Fromdate    ToDate
09:00AM      11:00 AM
02:00PM       03:00PM

How to do in an SQL procedure or statement?

Source Link

How to loop thru this array [[09:00 AM-11:00 AM],[02:00PM-03:00PM]

I have a table called Employee which has 2 column say FromDate and ToDate both are of type nvarchar(max). Now i am getting input like this [[09:00 AM-11:00 AM],[02:00PM-03:00PM] i have to insert each value in the fromdate and to date like below Fromdate ToDate 09:00AM 11:00 AM 02:00PM 03:00PM

How to do in sql procedure or query