chowdary10 Posted May 17, 2011 Author Report Posted May 17, 2011 [quote author=JAINTR link=topic=193762.msg2361669#msg2361669 date=1305608689]2 anukunta baa employeeID and employee incomes sCo_^Y[/quote] cry@fl cry@fl cry@fl[quote author=TollywoodEmperor link=topic=193762.msg2361670#msg2361670 date=1305608702]Baa dheeniki answer cheppu. sSa_j@il @3$% @3$% @3$% .and SQL server 2008lo chala new features vachayi..check them... Full text search index lantivi chudu ... H&*() H&*() H&*()[/quote]ba naaku vunna software televiki assalu vunte saalu.. malla updates ante kastam &*B@ &*B@
chowdary10 Posted May 17, 2011 Author Report Posted May 17, 2011 thankyou[quote author=HAPPYNESS link=topic=193762.msg2361674#msg2361674 date=1305608823]download adventure works data base from google...it is a free data base contains many number of tables. You can practice different queries ..... S%Hi S%Hi[/quote]
volley Posted May 17, 2011 Report Posted May 17, 2011 [quote author=KINDAL link=topic=193762.msg2361671#msg2361671 date=1305608737] *=: *=: *=: you rock you rock thankyouchusaanu ba baagundi.. ika sachinde sql.. naaku andaru w3schools annaru adi chadivithe nidra vacheedi... but this site is interesting CITI_$D# CITI_$D# thankyou[/quote]akkada questions adighadu kada baa.. so data insert chesi, aa questions ki queries raayi... and also, AdventureWorks database install chesi, queries raayi baa... chala help authadi.. S%Hi S%Hi
geeni83 Posted May 17, 2011 Report Posted May 17, 2011 [quote author=KINDAL link=topic=193762.msg2361678#msg2361678 date=1305608899] cry@fl cry@fl cry@flba naaku vunna software televiki assalu vunte saalu.. malla updates ante kastam &*B@ &*B@[/quote]kindal baa naku kuda sql kothe baa.. evaraina answer corest septhe sudaali baa..kindal baa nuvvu nerchukunedi naku kuda seppu ba nenu kuda interested... sadukunta nenu kuda
chipanjichiru Posted May 17, 2011 Report Posted May 17, 2011 [quote author=JAINTR link=topic=193762.msg2361669#msg2361669 date=1305608689]2 anukunta baa employeeID and employee incomes sCo_^Y[/quote][quote author=KINDAL link=topic=193762.msg2361666#msg2361666 date=1305608594]ba enni columns ba vachedi 4 correste na sSa_j@il[/quote]Baa akka 4 columns ani yela cheppagalavu baa..asalu aa tablelo yenni columns unnayo manaku teliyadhu kadha...OK coming to this one... Subquerieslo IN chesinappudu innerquery nunchi specific type of columns undali...IN compare cheyadaniki use chestharu...[size=36pt] Employee ID ni inner querylo vache results tho compare chesthunnamu..so innerquerylo vache result kuda employeeid datatype ayi undali[/size] But nenu ichina querylo innerquery nunchi anni columns vasthayi..compare cheyadam not possible..So ERROR vasthundhi...
king420 Posted May 17, 2011 Report Posted May 17, 2011 [quote author=KINDAL link=topic=193762.msg2361681#msg2361681 date=1305608963] thankyou[/quote]SSIS packages....kuda untai aa database lo... You tube lo SSIS, SSAS, SSRS videos chudu same alage practice chei...8mins videos untai thellodu cheptadu..ekkuva sodi lekunda direct matter ki vachestadu....
chipanjichiru Posted May 17, 2011 Report Posted May 17, 2011 [quote author=KINDAL link=topic=193762.msg2361678#msg2361678 date=1305608899] cry@fl cry@fl cry@flba naaku vunna software televiki assalu vunte saalu.. malla updates ante kastam &*B@ &*B@[/quote]Baa nee Email Id naku PM chesthe, nenu books pamputhanu..na daggara chala material undhi.... H&*() H&*()
geeni83 Posted May 17, 2011 Report Posted May 17, 2011 [quote author=TollywoodEmperor link=topic=193762.msg2361692#msg2361692 date=1305609198]Baa nee Email Id naku PM chesthe, nenu books pamputhanu..na daggara chala material undhi.... H&*() H&*()[/quote] naku kuda seyyi baa sSa_j@il sSa_j@il
king420 Posted May 17, 2011 Report Posted May 17, 2011 [quote author=TollywoodEmperor link=topic=193762.msg2361692#msg2361692 date=1305609198]Baa nee Email Id naku PM chesthe, nenu books pamputhanu..na daggara chala material undhi.... H&*() H&*()[/quote]mtrl nuvve nettikesi kottuko...kurrodiki videos emanna unte ivvu.....chusi practice cheskuntadu... aa pDF lu 100 la pages chadivite pichekkutundi [img]http://www.desigifs.com/sites/default/files/brahmam_plan1_0.gif?1290368421[/img]
chowdary10 Posted May 17, 2011 Author Report Posted May 17, 2011 [quote author=PSPK link=topic=193762.msg2361684#msg2361684 date=1305609032]akkada questions adighadu kada baa.. so data insert chesi, aa questions ki queries raayi... and also, AdventureWorks database install chesi, queries raayi baa... chala help authadi.. S%Hi S%Hi[/quote]sure baa.. melli ga doubts adugutha vunta get ready @3$% F@!n[quote author=JAINTR link=topic=193762.msg2361686#msg2361686 date=1305609089]kindal baa naku kuda sql kothe baa.. evaraina answer corest septhe sudaali baa..kindal baa nuvvu nerchukunedi naku kuda seppu ba nenu kuda interested... sadukunta nenu kuda [/quote]naa bathukkke kosthe okka query kuda raadu.. neeku emi septha baa @3$% !q#[quote author=TollywoodEmperor link=topic=193762.msg2361688#msg2361688 date=1305609099]Baa akka 4 columns ani yela cheppagalavu baa..asalu aa tablelo yenni columns unnayo manaku teliyadhu kadha...OK coming to this one... Subquerieslo IN chesinappudu innerquery nunchi specific type of columns undali...IN compare cheyadaniki use chestharu...[size=36pt] Employee ID ni inner querylo vache results tho compare chesthunnamu..so innerquerylo vache result kuda employeeid datatype ayi undali[/size] But nenu ichina querylo innerquery nunchi anni columns vasthayi..compare cheyadam not possible..So ERROR vasthundhi...[/quote]anukunna.. thanks for da explanation CITI_$D#so IN ani interviewr adigithe error ani seppeya mantaavu anthe kada @3$% H&T@[quote author=HAPPYNESS link=topic=193762.msg2361690#msg2361690 date=1305609125]SSIS packages....kuda untai aa database lo... You tube lo SSIS, SSAS, SSRS videos chudu same alage practice chei...8mins videos untai thellodu cheptadu..ekkuva sodi lekunda direct matter ki vachestadu....[/quote]chusta bava anni okkoti
chowdary10 Posted May 17, 2011 Author Report Posted May 17, 2011 [quote author=TollywoodEmperor link=topic=193762.msg2361692#msg2361692 date=1305609198]Baa nee Email Id naku PM chesthe, nenu books pamputhanu..na daggara chala material undhi.... H&*() H&*()[/quote]vammo sadavatam ayepoyendi ba vanley practice H&*()[quote author=HAPPYNESS link=topic=193762.msg2361696#msg2361696 date=1305609336]mtrl nuvve nettikesi kottuko...kurrodiki videos emanna unte ivvu.....chusi practice cheskuntadu... aa pDF lu 100 la pages chadivite pichekkutundi [img]http://www.desigifs.com/sites/default/files/brahmam_plan1_0.gif?1290368421[/img][/quote] @gr33d @gr33d @gr33d CITI_$D# CITI_$D#
chipanjichiru Posted May 17, 2011 Report Posted May 17, 2011 [quote author=KINDAL link=topic=193762.msg2361700#msg2361700 date=1305609370]so IN ani interviewr adigithe error ani seppeya mantaavu anthe kadha[/quote] @3$% @3$% @3$% IN vachi innerquerylo all retrieved ante error baa @3$% @3$% @3$%simple logic: where clause manam compare chese column datatype (EmployeeID - int) innerquerylo vache result datatyepe(int) same undali..otherwise error H&*() H&*() H&*()
chipanjichiru Posted May 17, 2011 Report Posted May 17, 2011 [quote author=HAPPYNESS link=topic=193762.msg2361696#msg2361696 date=1305609336]mtrl nuvve nettikesi kottuko...kurrodiki videos emanna unte ivvu.....chusi practice cheskuntadu... aa pDF lu 100 la pages chadivite pichekkutundi [img]http://www.desigifs.com/sites/default/files/brahmam_plan1_0.gif?1290368421[/img][/quote] @3$% @3$% @3$% @3$% books antha chadhavanasaram ledhu baa..just thanaki yekkada kastamga undho or new topics kanipisthe alantivi chudali #4H# #4H# #4H# #4H#
volley Posted May 17, 2011 Report Posted May 17, 2011 [quote author=KINDAL link=topic=193762.msg2361700#msg2361700 date=1305609370]sure baa.. melli ga doubts adugutha vunta get ready @3$% F@!n[/quote]anytime baaa... any doubt, anytime PM seyyi.. will explain u.. gud luck baa.. S%Hi
chowdary10 Posted May 17, 2011 Author Report Posted May 17, 2011 [quote author=TollywoodEmperor link=topic=193762.msg2361708#msg2361708 date=1305609566] @3$% @3$% @3$% IN vachi innerquerylo all retrieved ante error baa @3$% @3$% @3$%simple logic: where clause manam compare chese column datatype (EmployeeID - int) innerquerylo vache result datatyepe(int) same undali..otherwise error H&*() H&*() H&*()[/quote]got u ba H&*()define chesina data type and innerquery lo vachevi rendu okkate vundali[quote author=PSPK link=topic=193762.msg2361711#msg2361711 date=1305609722]anytime baaa... any doubt, anytime PM seyyi.. will explain u.. gud luck baa.. S%Hi[/quote] thankyou
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts