Jump to content

Recommended Posts

Posted

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 J@#D 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]

  • Replies 32
  • Created
  • Last Reply

Top Posters In This Topic

  • ChampakDas

    12

  • Silver_mani

    8

  • google2012

    7

  • mtkr

    2

Popular Days

Top Posters In This Topic

Posted

[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.....

Posted

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]

×
×
  • Create New...