1 2 3 4 5 6 7 8 9
|
SELECT id_class,id_level,
replace(left(id_level,patindex('%.%',id_level)),'.','') AS COL1,
replace(left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),''))),'.','') AS COL2,
replace(left(replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),''))),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),''))),''))),'.','') AS COL3,
replace(left(replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),'')))+left(replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),''))),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),''))),''))),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),'')))+left(replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),''))),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),''))),''))),''))),'.','') AS COL4,
replace(left(replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),'')))+left(replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),''))),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),''))),'')))+left(replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),'')))+left(replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),''))),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),''))),''))),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),'')))+left(replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),''))),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),''))),''))),''))),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),'')))+left(replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),''))),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),''))),'')))+left(replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),'')))+left(replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),''))),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),''))),''))),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),'')))+left(replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),''))),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level))+left(replace(id_level,left(id_level,patindex('%.%',id_level)),''),patindex('%.%',replace(id_level,left(id_level,patindex('%.%',id_level)),''))),''))),''))),''))),'.','') AS COL5
FROM kb_class
; |
Partager