I have a VB form that writes multiple dates to a column in a SQL Server 2005 tabIe. I would like to be able to pull out each individual date and write a new record to a seperate table and duplicate the additional information in that record. I assume I need to create some sort of split function but am not sure how to accomplish this.
Name | Dates
john Doe | 12/12/2007,12/13/2007, 12/14/2007,
I would like to have the records inserted into a new table..
Name | Date
John Doe | 12/12/2007
John Doe | 12/13/2007
John Doe | 12/14/2007
Any help would be appreciated.