[ nemshooo @ 20.05.2011. 19:49 ] @
| ApplySimpe statment je funkcija koja se koristi u OLAP alatu MicroStretegy. Ja sam sa neta skinuo jedan iskaz koji mi je potreban za generisanje novog atributa, medjutim, ne znam kako da ga prevedem u iskaz koji je validan u MSSQL 2008. Student sam, ucim alat pa mi treba pomoc. Code (sql): ApplySimple("CASE when ((months_between(sysdate, #0)) / 12) between 0 and 10 then '0 - 10' when ((months_between(sysdate, #0)) / 12) between 10 and 19 then '10 - 19' when ((months_between(sysdate, #0)) / 12) between 20 and 29 then '20 - 29' when ((months_between(sysdate, #0)) / 12) between 30 and 39 then '30 - 39' when ((months_between(sysdate, #0)) / 12) between 40 and 49 then '40 - 49' when ((months_between(sysdate, #0)) / 12) between 50 and 59 then '50 - 59' else '60+' end",dat_rodj) Razumem CASE WHEN (( )) BETWEEN 0 and 10 then '0-10' ..... from dat_rodj ..... , Hvala u napred. |