How do I convert a string of comma separated values into a database table?
Posted on 2011-09-08
I have a user table that looks like this, where AuthorizedDBList is a string that I use in an IN clause of an Access Database.
What I want is to convert to a SQL Server, Many-to-Many, AuthorizedDatabase table that looks like this.
My question is... how do I get from one to the other?