| Author |
Message |
    
Sinna
Bewarse ke Bewarse!
Username: Sinna
Post Number: 12108
Registered: 04-2005
Posted From: 68.226.155.92
| | Posted on Friday, April 07, 2006 - 3:11 pm: |    |
aunu vammo monna nenu 3 Q lu adiga nimishamlo cheppadu answer lu ento ayana mari 
Manchi ki Manchi Punch ki Punch that is Nandamuri NataSimha Balayya |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 14791
Registered: 03-2004
Posted From: 57.68.10.185
| | Posted on Friday, April 07, 2006 - 3:10 pm: | |
nayakudu mama lekapovatam manaki manchidayyindi. kiki. lekapothe tidin tidin ani ventane ans ichecvadu. kiki. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18459
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, April 07, 2006 - 3:08 pm: | |
 vaake gudi maama...thanx hemugaa.. |
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 1966
Registered: 11-2004
Posted From: 161.225.1.12
| | Posted on Friday, April 07, 2006 - 3:06 pm: | |
>>nee yenks...idhi eppatinuncho try seyyamani keyboard arigela typing settey ippudu try sesi work ayyindantaava>>
kaadhu issql select chesukookunda master select chesaa sql server database loo dropdown loo
adhi assalu mistaake
sorry guys  |
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 1965
Registered: 11-2004
Posted From: 161.225.1.12
| | Posted on Friday, April 07, 2006 - 3:03 pm: | |
rowdies koncham 4 weeks db looactive gaa vundandi
koosina queries rayali ok naaa
 |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18457
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, April 07, 2006 - 3:02 pm: | |
where trunc(workdate) > trunc(sysdate-3) edhi pani chesindi ooch
Thanks gochi and hemanthu
 nee yenks...idhi eppatinuncho try seyyamani keyboard arigela typing settey ippudu try sesi work ayyindantaava... |
Donga_evaru
Bewarse ke Bewarse!
Username: Donga_evaru
Post Number: 14815
Registered: 08-2004
Posted From: 134.130.240.42
| | Posted on Friday, April 07, 2006 - 3:01 pm: | |
gosiga, humgadu 1st time question adagakunda answering sethe adhi thappu antava  |
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 1964
Registered: 11-2004
Posted From: 161.225.1.12
| | Posted on Friday, April 07, 2006 - 2:59 pm: | |
where trunc(workdate) > trunc(sysdate-3) edhi pani chesindi ooch
Thanks gochi and hemanthu  |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18456
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, April 07, 2006 - 2:57 pm: | |
 atta aithe idhi try cheyyi maama....
where to_char(workdate,'MMDDYYYY') > to_char('04032006') |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18455
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, April 07, 2006 - 2:55 pm: | |
 hemugaa...correstey..adhi kooda pani sesindhi... |
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 1963
Registered: 11-2004
Posted From: 161.225.1.12
| | Posted on Friday, April 07, 2006 - 2:54 pm: | |
trunc ni SQL server recognise cheyyadhu anta
error message 197 vastandhi
trunc teseesthee error message 207 vastandi  |
Sinna
Bewarse ke Bewarse!
Username: Sinna
Post Number: 12104
Registered: 04-2005
Posted From: 68.226.155.92
| | Posted on Friday, April 07, 2006 - 2:54 pm: | |
Aaa nuvvu Simputhunte soothoo korsuntada enti Gochi edo okati ceyyadu
Manchi ki Manchi Punch ki Punch that is Nandamuri NataSimha Balayya |
Sinna
Bewarse ke Bewarse!
Username: Sinna
Post Number: 12103
Registered: 04-2005
Posted From: 68.226.155.92
| | Posted on Friday, April 07, 2006 - 2:54 pm: | |
Madhyalo nee G em cesindi
Manchi ki Manchi Punch ki Punch that is Nandamuri NataSimha Balayya |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 14790
Registered: 03-2004
Posted From: 57.68.10.185
| | Posted on Friday, April 07, 2006 - 2:53 pm: | |
nenu ippati varaku rasindi adokkate, adi ala kadu ante nee Gochi sirigipodhi. |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 14789
Registered: 03-2004
Posted From: 57.68.10.185
| | Posted on Friday, April 07, 2006 - 2:52 pm: | |
Nee G le, nenu eppudu attage rasthanu, rasi chosuko. kiki. |
Pokiri1
Pilla Bewarse
Username: Pokiri1
Post Number: 49
Registered: 03-2006
Posted From: 152.123.2.230
| | Posted on Friday, April 07, 2006 - 2:52 pm: | |
gochi
 |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18454
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, April 07, 2006 - 2:51 pm: | |
where trunc(workdate) > trunc(sysdate) - 3
 itta raasthey oracle egiri egiri thanthadhi...
where trunc(workdate) > trunc(sysdate-3) itta raayali  |
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 1962
Registered: 11-2004
Posted From: 161.225.1.12
| | Posted on Friday, April 07, 2006 - 2:50 pm: | |
ee roju ninna monnati vi kavali mama
history report undi
daniki
|
Pokiri1
Pilla Bewarse
Username: Pokiri1
Post Number: 48
Registered: 03-2006
Posted From: 152.123.2.230
| | Posted on Friday, April 07, 2006 - 2:50 pm: | |
hemu gochi mama cheppindi ade |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18453
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, April 07, 2006 - 2:49 pm: | |
 hemanthgaa... |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 14788
Registered: 03-2004
Posted From: 57.68.10.185
| | Posted on Friday, April 07, 2006 - 2:49 pm: | |
where trunc(workdate) > trunc(sysdate) - 3 |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18452
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, April 07, 2006 - 2:48 pm: | |
 indaaka mari 3 days mundari unna data annavu...ippudemo last 3 days ki daata kaavalantav...edhi kaavalo sarigga seppu... |
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 1961
Registered: 11-2004
Posted From: 161.225.1.12
| | Posted on Friday, April 07, 2006 - 2:41 pm: | |
emi ayipoyaru andaru
 |
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 1960
Registered: 11-2004
Posted From: 161.225.1.12
| | Posted on Friday, April 07, 2006 - 2:34 pm: | |
select * from itemstorechanges
where datediff(day, WorkDate, getdate()) between 0 and 3
etta rayavoccha ?? |
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 1959
Registered: 11-2004
Posted From: 161.225.1.12
| | Posted on Friday, April 07, 2006 - 2:31 pm: | |
vacchi chavtlaa ..
oDBC error ani vastandi
detailed gaa chebuthunna choodu
itemstorechanges table
fields
workdate 2006-04-07 16:26:10.000
store_i 1356
dept_i 878
class_i 6
item_i 6223
tran_c 258
eppudu cheppu 3 days ki report ettla query cheyyali
 |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18451
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, April 07, 2006 - 2:17 pm: | |
thanxu kiri maama...gudi maama.. spelling secking seyyi..lekapothe aa error ento ikkada postu |
Pokiri1
Pilla Bewarse
Username: Pokiri1
Post Number: 47
Registered: 03-2006
Posted From: 152.123.2.230
| | Posted on Friday, April 07, 2006 - 2:16 pm: | |
naku pani chesidi nee query gochi mama
oorikine try chesa |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18450
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, April 07, 2006 - 2:14 pm: | |
kiri maama...usualgaa timestamp column chaala tableslo kaavalani pedathaaru..adhi work date 99% same untaayi...adhi format kosam kaadu |
Pokiri1
Pilla Bewarse
Username: Pokiri1
Post Number: 46
Registered: 03-2006
Posted From: 152.123.2.230
| | Posted on Friday, April 07, 2006 - 2:14 pm: | |
MM/DD/RRRR HH:MI AM ichhadu |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18449
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, April 07, 2006 - 2:13 pm: | |
 trunc pedithe work avvali aa format etta edisinaa...try sesaava |
Pokiri1
Pilla Bewarse
Username: Pokiri1
Post Number: 45
Registered: 03-2006
Posted From: 152.123.2.230
| | Posted on Friday, April 07, 2006 - 2:13 pm: | |
workdate ki format ichhadu mama |
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 1958
Registered: 11-2004
Posted From: 161.225.129.111
| | Posted on Friday, April 07, 2006 - 2:12 pm: | |
4/7/2006 1:46:53 PM ela timestamp sacchindi workdate loo |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18448
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, April 07, 2006 - 2:11 pm: | |
 atta aithe trunc(timestamp) < trunc(sysdate-3) ettuko |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18447
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, April 07, 2006 - 2:10 pm: | |
spellings sarigga raasavo ledho soodu...adhe column_name,table name |
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 1957
Registered: 11-2004
Posted From: 161.225.129.111
| | Posted on Friday, April 07, 2006 - 2:10 pm: | |
Danemma aa work date ki Time stamp okkati dobbinchukundi |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18446
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, April 07, 2006 - 2:10 pm: | |
trunc ettukunte koosantha better maayya...
select * from itemstorechanges
where trunc(workdate) < trunc(sysdate-3) |
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 1956
Registered: 11-2004
Posted From: 161.225.129.111
| | Posted on Friday, April 07, 2006 - 2:09 pm: | |
error vastandi emiti
|
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 18445
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Friday, April 07, 2006 - 2:07 pm: | |
select * from itemstorechanges
where workdate < sysdate-3 |
Gudiwada
Bewarse
Username: Gudiwada
Post Number: 1955
Registered: 11-2004
Posted From: 161.225.129.111
| | Posted on Friday, April 07, 2006 - 2:04 pm: | |
babailu sql statement rayali..
3 days back date varakee records display avvali report loo
elaa rayaali
WorkDate store_i dept_i class_i item_i tran_c
4/7/2006 1473 880 1 1060 258
table peru itemstorechanges |
