Here is quick SQL function to convert list to table.

The above query exploits the Xquery capabilities of SQL Server to split the delimited values. The function can be used as shown below sql function to convert list to table There are other methods too however I found this quick and easy.   Regards Ahmad Osama Like us on FaceBook Join the fastest growing SQL Server group on FaceBook Follow me on TwitterFollow me on FaceBook