SQL Query - You Can (1)

I have a table with with entries.

Need to split , separated value to create detail entries like as under

1. Best practices for designing and developing cubes
   http://msdn.microsoft.com/en-us/library/cc966399.aspx#EDAA
2. What is Degenerate or junk dimension?
   http://technet.microsoft.com/en-us/library/ms167409.aspx
3. Explain with an example how many-to-many dimension usage works?
4. What is the use of ADOMD.NET data provider?
5. What do you understand by MDX, DMX, ASSL?
6. What are the system tables and their usage - sysobject, syscomments?
7. When do we execute query using OpenQuery or OpenRowSet command?
   http://www.sqlyoga.com/2009/04/sql-server-difference-between-openquery.html
8. How to process large dimension / cube partition?
   http://www.artisconsulting.com/blogs/greggalloway/Lists/Posts/Post.aspx?ID=7
9. What is the use of AMO (Analysis Management Object)?
   http://msdn.microsoft.com/en-us/library/ms345084(v=SQL.90).aspx
10. In Which Scenarios incremental loading should be done.
    http://vsteamsystemcentral.com/cs21/blogs/applied_business_intelligence/archive/2007/05/21/ssis-design-pattern-incremental-loads.aspx
11. Rank() and Partition by in SQL?
12. Type of slowly changing dimensions?
    http://www.mssqltips.com/tip.asp?tip=1442
13. Merge or Conditional split to load incremental data?
    http://consultingblogs.emc.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx
14. Difference between multicast and conditional split tasks?
    http://consultingblogs.emc.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspx
15. Event handling in SSIS
16. Explain parent-child dimension?
17. Cube securing without Active Directory.
18. Report deployment, native mode and share point mode?
19. Partitioning Strategy for cube
20. Should we select materalize in the dimension usage?
    http://msdn.microsoft.com/en-us/library/ms178448.aspx
21. ETL packate configurations and when to use which one?
    http://www.mssqltips.com/tip.asp?tip=1405
22. Parent and child package variables and call.
23. SQL server and file system package deployment
24. Execute child pacakge using execute pkg or execute process tasks?
25. DTEXEC to execute package and various parameters.
    http://msdn.microsoft.com/en-us/library/ms162810.aspx
26. How to call package using job?
27. Managing and running etl packages?
    http://technet.microsoft.com/en-us/library/cc966389.aspx
28. Create, build and publish reports and model?
    http://www.accelebrate.com/sql_training/ssrs_2008_tutorial.htm
29. Report server and report temp db roles?
30. MDX - Set, tuples, named query etc.
    http://www.databasejournal.com/features/mssql/article.php/10894_3325131_2/MDX-in-Analysis-Services-Named-Sets-in-MDX-An-Introduction.htm
31. Handling slowly changing dimension in SSIS if lot of records required to be processed.
    http://blogs.msdn.com/b/mattm/archive/2009/11/13/handling-slowly-changing-dimensions-in-ssis.aspx