Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
boris1610
Starting Member
3 Posts |
 Posted - 2014-10-11 : 15:33:49
|
Hi every bodyI'm trying to convert this oracle statement in sql server 2012 but without result can somebody help me with this?? ' ( '||Format(TO_DATE('15aug2011'),'DD-MM-YYYY' )||' )TOT( '||Format(TO_DATE('16dec2011'),'DD-MM-YYYY' ) ||' ) 'PERIODE, SUBSTRING (TRUNC(((X1.Rood * 100) / (P.Aantal_AANGIFTEN)),2),1,10)||' %' Rood, SUBSTRING(TRUNC(((X2.Geel * 100) / (P.Aantal_AANGIFTEN)),2),1,10)||' %' Geel, SUBSTRING(TRUNC(((X3.Blauw * 100) / (P.Aantal_AANGIFTEN)),2) ,1,10)||' %'Blauw, SUBSTRING(TRUNC(((X4.Groen * 100) / (P.Aantal_AANGIFTEN)),2),1,10)||' %' Groen![]() fons_jansen@yahoo.com |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-10-12 : 14:59:17
|
| Can you explain in words what this does, since not every one can read Oracle's SQL (I know I can't) |
 |
|
|
|
|
|
|
|
concatenate with qoute oracal versus sql server