ChampakDas Posted June 14, 2012 Author Report Posted June 14, 2012 CASE tho try chesi aa query copy chesa, its working..DECODE is not recognized in MSSQL... If CASE doesnt handle NULL then MS would have sure come up with something similar to DECODE..point aa kada MS rocks!! [quote name='google2012' timestamp='1339647786' post='1301965285'] oka sari oka DB create chesi dantlo case toh and decode to NULL value paas chesi result chudu oka sari.. u will know the difference as how case handles NULL ani... [/quote]
mtkr Posted June 14, 2012 Report Posted June 14, 2012 [quote name='ChampakDas' timestamp='1339646248' post='1301965195'] For the first day, 3 seconds will be behind. So, to complete the second day this 3 seconds needs to be completed kada. So, I was thinking it will be (3) + (3+3) + (3+3+3) [/quote] ikkada per sec calculate cheyyali anukuntaa mama... b/c oka day ki 3 sec loss so 86400 sec ki 3sec loss.... so per sec cal chesiiii... aa RES ni 3 times add cheyyali for one day(b/c 3 sec less).... so ila 3 days ki cheyyaliii... res wil be 9.07 or 9.007 something.....
ChampakDas Posted June 14, 2012 Author Report Posted June 14, 2012 Correct ani anipistundhi but at the same time nadhi kuda correct a anipistundhi.. oka program rastunna deniki..will come up with the result.. [quote name='mtkr' timestamp='1339648730' post='1301965351'] ikkada per sec calculate cheyyali anukuntaa mama... b/c oka day ki 3 sec loss so 86400 sec ki 3sec loss.... so per sec cal chesiiii... aa RES ni 3 times add cheyyali for one day(b/c 3 sec less).... so ila 3 days ki cheyyaliii... res wil be 9.07 or 9.007 something..... [/quote]
Recommended Posts