| Author |
Topic |
|
artbishop
Starting Member
18 Posts |
 Posted - 2010-02-08 : 02:35:00
|
| I am new to sql and could anyone help me distribute a,b,c,d,and so on.. to individual rows..1 a2 b3 c4 d5 e6 fa,b,c,d,e,f,g,h,i, are entered in one field i.e. TESTFIELDthank you |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-02-08 : 03:03:48
|
| declare @tbl as table(val varchar(20)) insert into @tbl select 'a'union all select 'b'union all select 'c'union all select 'd'union all select 'e' declare @str varchar(max) set @str='' select @str= @str + ',' + val from @tbl select @strPBUH |
 |
|
|
artbishop
Starting Member
18 Posts |
Posted - 2010-02-08 : 03:07:42
|
| i was trying to follow the steps posted here.. [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76033#315323[/url] |
|
|
|
artbishop
Starting Member
18 Posts |
Posted - 2010-02-08 : 03:14:16
|
| my question is also similar to the question posted in : [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=135470&SearchTerms=delimit[/url]where I need to split data into individual rows... |
|
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
|
|
artbishop
Starting Member
18 Posts |
Posted - 2010-02-08 : 04:14:19
|
| ...not working ... =( |
|
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2010-02-08 : 04:15:51
|
| What You tried post your query!Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
|
|
|
artbishop
Starting Member
18 Posts |
Posted - 2010-02-08 : 04:21:03
|
| i can't make it work using dreamweaver...i don't know if it is possible to include it as a recordset |
|
|
|
artbishop
Starting Member
18 Posts |
Posted - 2010-02-08 : 04:23:07
|
| i tried the article posted by Transac Charlie and it's working when I use SQL query..however, I can't make it work when I try to use it within dreamweaver (asp file) http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=119254&SearchTerms=delimit |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-08 : 05:09:32
|
| why cant you make it a udf and call from dreamweaver code? |
|
|
|
|
distribute a,b,c,d, and so on in individual rows