I a row on a pretty big sql table that i need to make into 2 rows. The row is set up like "user - date" like "buyanswerslinks - October 16, 2008". I need to take that and break it into 3 separate rows, one for the user and the other for the date.

I know how to create the rows, alter rows, change the date, etc. but how do I make a script that grabs a the output and then add it to another row?

If someone could get me start on the code that would be awesome