| Author |
Message |
    
Gaali
Desanike Pedda Bewarse
Username: Gaali
Post Number: 8653
Registered: 03-2004
Posted From: 199.26.230.102
| | Posted on Monday, October 17, 2005 - 9:38 am: |    |
Pillalu yevaro answers yichesaaru gaa. Ayithe naa avasaram ledanna maata.  |
Godfather
Bewarse ke Bewarse!
Username: Godfather
Post Number: 28729
Registered: 03-2004
Posted From: 217.157.60.18
| | Posted on Monday, October 17, 2005 - 9:00 am: | |
 |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 11206
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, October 17, 2005 - 9:00 am: | |
 GF maayyaa...seeghra scale problemaa |
Godfather
Bewarse ke Bewarse!
Username: Godfather
Post Number: 28722
Registered: 03-2004
Posted From: 217.157.60.18
| | Posted on Monday, October 17, 2005 - 8:50 am: | |
 |
Babu
Desanike Pedda Bewarse
Username: Babu
Post Number: 6853
Registered: 06-2004
Posted From: 65.208.22.25
| | Posted on Monday, October 17, 2005 - 8:48 am: | |
>> manam modaletam kani modaledute entha sepu..
antha eeka  |
Godfather
Bewarse ke Bewarse!
Username: Godfather
Post Number: 28721
Registered: 03-2004
Posted From: 217.157.60.18
| | Posted on Monday, October 17, 2005 - 8:46 am: | |
dimbsa ledu ley chesi dobba.. manam modaletam kani modaledute entha sepu..  |
Rediff
Vooriki Bewarse
Username: Rediff
Post Number: 5523
Registered: 03-2004
Posted From: 67.176.15.43
| | Posted on Monday, October 17, 2005 - 8:45 am: | |
Dimbsaa 
GF mama  |
Godfather
Bewarse ke Bewarse!
Username: Godfather
Post Number: 28719
Registered: 03-2004
Posted From: 217.157.60.18
| | Posted on Monday, October 17, 2005 - 8:41 am: | |
koncham alavatu chesukovali mama lekapote debbadi potundi..  |
Dimbaka
Desanike Pedda Bewarse
Username: Dimbaka
Post Number: 10214
Registered: 03-2004
Posted From: 64.94.44.180
| | Posted on Monday, October 17, 2005 - 8:40 am: | |
intakee correct statement rasava leka aa table lonchi
rendu, ee table lonchi rendu lines copy-paste sesi
mee manager ni bluff sesava?  |
Rediff
Vooriki Bewarse
Username: Rediff
Post Number: 5520
Registered: 03-2004
Posted From: 67.176.15.43
| | Posted on Monday, October 17, 2005 - 8:39 am: | |
alaa ani aapset ayipoyi daily cheseyamaaku.. alavaatayipoddi |
Godfather
Bewarse ke Bewarse!
Username: Godfather
Post Number: 28715
Registered: 03-2004
Posted From: 217.157.60.18
| | Posted on Monday, October 17, 2005 - 8:36 am: | |
hamaya pani ayindi.. .. epudo oka sari panulu cheste vunte illage vuntundi anukunta.. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 11200
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, October 17, 2005 - 8:22 am: | |
 diffu... |
Rediff
Vooriki Bewarse
Username: Rediff
Post Number: 5518
Registered: 03-2004
Posted From: 67.176.15.43
| | Posted on Monday, October 17, 2005 - 8:20 am: | |
Gochiyoo..  |
Rediff
Vooriki Bewarse
Username: Rediff
Post Number: 5517
Registered: 03-2004
Posted From: 67.176.15.43
| | Posted on Monday, October 17, 2005 - 8:20 am: | |
SQL ante eti?....sex quality lab????
so.. aa S gurnchi GF mamaki emee teleedu antaavaa |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 11199
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Monday, October 17, 2005 - 8:19 am: | |
Select
x.a,
x.b,
x.c
y.a
y.d
y.e
from
x
y
where x.a=y.a
and y.e is not null
group by
nee istamochina order
|
Kasakbabu
Desanike Pedda Bewarse
Username: Kasakbabu
Post Number: 9306
Registered: 11-2004
Posted From: 203.200.95.130
| | Posted on Monday, October 17, 2005 - 8:04 am: | |
|
Infinity
Vooriki Bewarse
Username: Infinity
Post Number: 4755
Registered: 04-2005
Posted From: 66.27.208.16
| | Posted on Monday, October 17, 2005 - 8:02 am: | |
nuvve answer kooda ichav gaa kasak  mee IITians inthena? |
Infinity
Vooriki Bewarse
Username: Infinity
Post Number: 4754
Registered: 04-2005
Posted From: 66.27.208.16
| | Posted on Monday, October 17, 2005 - 8:02 am: | |
life is OK mama..
how abt you? hope everything is fine with you |
Kasakbabu
Desanike Pedda Bewarse
Username: Kasakbabu
Post Number: 9304
Registered: 11-2004
Posted From: 203.200.95.130
| | Posted on Monday, October 17, 2005 - 7:57 am: | |
pani paata ledaa poddunne DB meeda paddaaru anthaa |
Babu
Desanike Pedda Bewarse
Username: Babu
Post Number: 6851
Registered: 06-2004
Posted From: 65.208.22.25
| | Posted on Monday, October 17, 2005 - 7:56 am: | |
tunts mama 
howz life treating u |
Infinity
Vooriki Bewarse
Username: Infinity
Post Number: 4747
Registered: 04-2005
Posted From: 66.27.208.16
| | Posted on Monday, October 17, 2005 - 7:52 am: | |
babu, prassu
Pd mama: naaku antha scene illio.. edo naa C code test cheyyali ante... database lo SQL queries raayali anduke inni tippalu.. ee terminology |
Babu
Desanike Pedda Bewarse
Username: Babu
Post Number: 6848
Registered: 06-2004
Posted From: 65.208.22.25
| | Posted on Monday, October 17, 2005 - 7:47 am: | |
horny needhi naadi oke pinch 
attanti technical words guthetukotam kattam  |
Prasanth
Bewarse ke Bewarse!
Username: Prasanth
Post Number: 20391
Registered: 03-2004
Posted From: 203.200.218.2
| | Posted on Monday, October 17, 2005 - 7:47 am: | |
kaadhu bangalorelo unnaadu..mallee call chesinappudu cheptaale. |
Babu
Desanike Pedda Bewarse
Username: Babu
Post Number: 6847
Registered: 06-2004
Posted From: 65.208.22.25
| | Posted on Monday, October 17, 2005 - 7:46 am: | |
prassu..brad mama hyd lo unnada..
week lo ayithe kaluddam..
weekend ki tirupathi ki payanam  |
Proofdada
Bewarse ke Bewarse!
Username: Proofdada
Post Number: 30761
Registered: 03-2004
Posted From: 80.121.144.9
| | Posted on Monday, October 17, 2005 - 7:46 am: | |
>>infact do you know that.. few databases generate transitive closure conditions when it sees transitive closure property
infy mayya yeemi basha idi....neenu ms loo yedhoo thoakklo exam raasanu kaani...itlaa tech words gurthunchukoolee....neenu dir gaa attacking icha mama sql ku with out proper knowledge..exp thoo neerchukunnade...and neenu program loone chaala varaku solve chesukuntaa data thechukuni...prob yentantee sql neerchukovatnaiki ollu baddakam... |
Kasakbabu
Desanike Pedda Bewarse
Username: Kasakbabu
Post Number: 9303
Registered: 11-2004
Posted From: 203.200.95.130
| | Posted on Monday, October 17, 2005 - 7:45 am: | |
avunaa brad maaya hyd lo unnaadaa?....adigaanani cheppu...... |
Prasanth
Bewarse ke Bewarse!
Username: Prasanth
Post Number: 20390
Registered: 03-2004
Posted From: 203.200.218.2
| | Posted on Monday, October 17, 2005 - 7:44 am: | |
babu maayya
ipude brad mama call chesaadu. details ph.lo cheptale.
II to ninna maatlaada. ee week lo kaluddaam annaadu. ellundi naaku selava. infotsav kada. so evening 5 daaka kaali appudu. |
Babu
Desanike Pedda Bewarse
Username: Babu
Post Number: 6846
Registered: 06-2004
Posted From: 65.208.22.25
| | Posted on Monday, October 17, 2005 - 7:43 am: | |
>>data nee ledu..
nee burra lo laagana |
Babu
Desanike Pedda Bewarse
Username: Babu
Post Number: 6845
Registered: 06-2004
Posted From: 65.208.22.25
| | Posted on Monday, October 17, 2005 - 7:42 am: | |
gf ga aa error edo cheppu..appudu cheppochu |
Proofdada
Bewarse ke Bewarse!
Username: Proofdada
Post Number: 30760
Registered: 03-2004
Posted From: 80.121.144.9
| | Posted on Monday, October 17, 2005 - 7:42 am: | |
u r rite infy mayya , i was checking diff condition... |
Infinity
Vooriki Bewarse
Username: Infinity
Post Number: 4745
Registered: 04-2005
Posted From: 66.27.208.16
| | Posted on Monday, October 17, 2005 - 7:42 am: | |
programming languages lo manam data set ni processing lo emanna wrong kaavochu emo kaani... database lo internal gaa processing totally different mama. it should work.
infact do you know that.. few databases generate transitive closure conditions when it sees transitive closure property. like when you have conditions like t1.x1 = t2.x2 and x2 = 10.. it derives another condition x1 = 10. it helps search space in the database. response time increases. |
Godfather
Bewarse ke Bewarse!
Username: Godfather
Post Number: 28714
Registered: 03-2004
Posted From: 217.157.60.18
| | Posted on Monday, October 17, 2005 - 7:42 am: | |
mamalu thanks.. nenu first raasina query work ayindi.. data output emi lekapote nenu kangaru padda.. ipude chusa nenu vere database lo working akkada data nee ledu..
|
Kasakbabu
Desanike Pedda Bewarse
Username: Kasakbabu
Post Number: 9302
Registered: 11-2004
Posted From: 203.200.95.130
| | Posted on Monday, October 17, 2005 - 7:42 am: | |
GF maaaya maree ekkuva pani seyyabaaka aaroggem debbathintyaadi |
Proofdada
Bewarse ke Bewarse!
Username: Proofdada
Post Number: 30759
Registered: 03-2004
Posted From: 80.121.144.9
| | Posted on Monday, October 17, 2005 - 7:38 am: | |
infy mama.....r u sure on this....as u check the values in for/while loops in normal programming language....it give diff results in normal loops....and i faced thses prob once and i learned that it differs..anyway nenu check chesukuntanu oracle loo... |
Infinity
Vooriki Bewarse
Username: Infinity
Post Number: 4743
Registered: 04-2005
Posted From: 66.27.208.16
| | Posted on Monday, October 17, 2005 - 7:35 am: | |
think x.a = y.a differs with
y.a = x.a
nope. this is symmetric property. it should not differ. |
Infinity
Vooriki Bewarse
Username: Infinity
Post Number: 4742
Registered: 04-2005
Posted From: 66.27.208.16
| | Posted on Monday, October 17, 2005 - 7:34 am: | |
cross join is kind of join to product join tables. it should not be a problem.
SQL server nenu use cheyyaledu mama. but it should work.
oka question: null checking ki SQL server lo command enti?
column A in both the tables is a non NULL column right? check if it is a nullable column or not? let me know what kind of column it was. |
Kasakbabu
Desanike Pedda Bewarse
Username: Kasakbabu
Post Number: 9301
Registered: 11-2004
Posted From: 203.200.95.130
| | Posted on Monday, October 17, 2005 - 7:34 am: | |
SQL ante eti?....sex quality lab???? |
Proofdada
Bewarse ke Bewarse!
Username: Proofdada
Post Number: 30758
Registered: 03-2004
Posted From: 80.121.144.9
| | Posted on Monday, October 17, 2005 - 7:32 am: | |
i think x.a = y.a differs with
y.a = x.a
cross check with this ..might get diff dataset.... |
Godfather
Bewarse ke Bewarse!
Username: Godfather
Post Number: 28713
Registered: 03-2004
Posted From: 217.157.60.18
| | Posted on Monday, October 17, 2005 - 7:32 am: | |
tuntio, cross join ante enti ? sql server using.. x,y ani raastunte adi adi x cross join y ani change avutundi.. |
Infinity
Vooriki Bewarse
Username: Infinity
Post Number: 4741
Registered: 04-2005
Posted From: 66.27.208.16
| | Posted on Monday, October 17, 2005 - 7:30 am: | |
PD mama. nenu cheppina sql aa pani cheyyali. |
Infinity
Vooriki Bewarse
Username: Infinity
Post Number: 4740
Registered: 04-2005
Posted From: 66.27.208.16
| | Posted on Monday, October 17, 2005 - 7:30 am: | |
ee database vaadutunnavu. emi output vachindi? edanna error aa?
how do you want it.. exactly? i did not see any problem wiht it. |
Proofdada
Bewarse ke Bewarse!
Username: Proofdada
Post Number: 30757
Registered: 03-2004
Posted From: 80.121.144.9
| | Posted on Monday, October 17, 2005 - 7:28 am: | |
as i am week in sql....
i use to find these null values in my c++ program itself by using
_variant_t v1;
short sh1;
if they are using c++,c# i can tell the solution in my way....if somebody gives simple sql stamt i will learn from that... |
Godfather
Bewarse ke Bewarse!
Username: Godfather
Post Number: 28712
Registered: 03-2004
Posted From: 217.157.60.18
| | Posted on Monday, October 17, 2005 - 7:28 am: | |
kiki adee raasanu.. kani ravataledu..edo output vastundi.. |
Infinity
Vooriki Bewarse
Username: Infinity
Post Number: 4738
Registered: 04-2005
Posted From: 66.27.208.16
| | Posted on Monday, October 17, 2005 - 7:26 am: | |
sel <columns from x>, <columns from y> from x, y
where x.a = y.a and y.e is NULL; |
Godfather
Bewarse ke Bewarse!
Username: Godfather
Post Number: 28709
Registered: 03-2004
Posted From: 217.157.60.18
| | Posted on Monday, October 17, 2005 - 7:23 am: | |
//naa output shld be x.a=x.y where y.e=null
sorry.. x.a=y.a |
Godfather
Bewarse ke Bewarse!
Username: Godfather
Post Number: 28708
Registered: 03-2004
Posted From: 217.157.60.18
| | Posted on Monday, October 17, 2005 - 7:22 am: | |
indakata nunchi oka basic sql rayataniki sattuna..koncham help cheyara..
TABLE X lo a,b,c ane fields
TABLE Y lo a,d,e ane fields..
naa output shld be x.a=x.y where y.e=null
ee stmt tho vunna ani records list vacheyala.. simple gaa chepeyandi.. |
