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