1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
|
select left(row_info,patIndex('%.%',row_info )-1 ),
LEFT(SUBSTRING( row_info,patIndex('%.%',row_info )+1,Len(row_info)),patIndex('%.%',SUBSTRING(row_info, patIndex('%.%',row_info )+1,Len(row_info)) )-1
),
LEFT(
SUBSTRING(
SUBSTRING( row_info,patIndex('%.%',row_info )+1,Len(row_info)),
patIndex('%.%',SUBSTRING( row_info,patIndex('%.%',row_info )+1,Len(row_info)) )+1,
Len(SUBSTRING( row_info,patIndex('%.%',row_info )+1,Len(row_info)))
),
patIndex('%.%',SUBSTRING(
SUBSTRING( row_info,patIndex('%.%',row_info )+1,Len(row_info)),
patIndex('%.%',SUBSTRING( row_info,patIndex('%.%',row_info )+1,Len(row_info)) )+1
,Len(SUBSTRING( row_info,patIndex('%.%',row_info )+1,Len(row_info)))) )
-1)
,
RIGHT(
SUBSTRING(
SUBSTRING( row_info,patIndex('%.%',row_info )+1,Len(row_info)),
patIndex('%.%',SUBSTRING( row_info,patIndex('%.%',row_info )+1,Len(row_info)) )+1,
Len(SUBSTRING( row_info,patIndex('%.%',row_info )+1,Len(row_info)))
)
,
patIndex('%.%',REVERSE(SUBSTRING(
SUBSTRING( row_info,patIndex('%.%',row_info )+1,Len(row_info)),
patIndex('%.%',SUBSTRING( row_info,patIndex('%.%',row_info )+1,Len(row_info)) )+1
,Len(SUBSTRING( row_info,patIndex('%.%',row_info )+1,Len(row_info)))) ))
-1)
from CONTRACT_PERIOD_VOLUME |
Partager