Difficult Select Query
-
Hi, i want to get data from table, which has data like that: ColA ColB 1 12.324.145 2 425.152.643 3 12 After Select the results must be like: 1 12 1 324 1 145 2 425 ... 3 12 How can i do this?
-
Hi, i want to get data from table, which has data like that: ColA ColB 1 12.324.145 2 425.152.643 3 12 After Select the results must be like: 1 12 1 324 1 145 2 425 ... 3 12 How can i do this?
Do a search on split procedures.
Mongo: Mongo only pawn... in game of life.
-
Hi, i want to get data from table, which has data like that: ColA ColB 1 12.324.145 2 425.152.643 3 12 After Select the results must be like: 1 12 1 324 1 145 2 425 ... 3 12 How can i do this?
create table #tmp (ColA varchar(2),ColB varchar(100)) insert into #tmp select '1', '12.324.145' union all select '2', '425.152.643' union all select '3', '12' select a.ColA,t.c.value('.','varchar(100)') as col2 from (select cola,cast(''+replace(colB,'.','')+'' as xml) as c2 from #tmp) a cross apply c2.nodes('/t') t(c)