asked
please can this question answer me
this is my emp table id name 1 a,b,c,d i want output is id name 1 a 1 b 1 c 1 d please can fine above o/p result to find query
The problem has been covered numerous times on this site. Here are a few previous questions/answers that may get you going: [
http://ask.sqlservercentral.com/questions/105789/i-have-one-column-its-having-aaaaaaabbbaabaac-valu.html][1] [
http://ask.sqlservercentral.com/questions/90968/how-do-i-extract-data-from-a-variable-length-delim.html][2] [
http://ask.sqlservercentral.com/questions/23117/how-has-splitting-a-delimited-string-improved-sinc.html][3] "delimited-string" even has its own tag if you'd like to see more: [
http://ask.sqlservercentral.com/questions/topics/delimited-string.html?sort=active&pageSize=50][4] [1]:
http://ask.sqlservercentral.com/questions/105789/i-have-one-column-its-having-aaaaaaabbbaabaac-valu.html [2]:
http://ask.sqlservercentral.com/questions/90968/how-do-i-extract-data-from-a-variable-length-delim.html [3]:
http://ask.sqlservercentral.com/questions/23117/how-has-splitting-a-delimited-string-improved-sinc.html [4]:
http://ask.sqlservercentral.com/questions/topics/delimited-string.html?sort=active&pageSize=50
15 People are following this question.
