deals2buy Posted January 12, 2013 Report Posted January 12, 2013 How you find records that exist in one table and do not exist in another table?
mtkr Posted January 12, 2013 Report Posted January 12, 2013 [quote name='Kaarthikeya' timestamp='1358011050' post='1303097204'] script task raayi..to add leading zeroes..that would be the best solution always [/quote] scrpt tsk enduku mama.... derived column trns tho chesukovochu gaaa!!! [quote name='Kaarthikeya' timestamp='1358011302' post='1303097224'] How you find records that exist in one table and do not exist in another table? [/quote] joins....
deals2buy Posted January 13, 2013 Report Posted January 13, 2013 [quote name='mtkr' timestamp='1358018657' post='1303097764'] scrpt tsk enduku mama.... derived column trns tho chesukovochu gaaa!!! [/quote] ante okasari script raasesukunte future lo enni sarlu aina adi use chesukovachu kada [quote name='mtkr' timestamp='1358018657' post='1303097764'] joins.... [/quote] only joins aa? inka vere options em leva?
ghazni Posted January 13, 2013 Report Posted January 13, 2013 [quote name='Kaarthikeya' timestamp='1358044365' post='1303099065'] only joins aa? inka vere options em leva? [/quote] undi mama edo nenu use chesa adi kani gurtu ravadam ledu.. its like not exists....
mtkr Posted January 13, 2013 Report Posted January 13, 2013 [quote name='Kaarthikeya' timestamp='1358044365' post='1303099065'] ante okasari script raasesukunte future lo enni sarlu aina adi use chesukovachu kada only joins aa? inka vere options em leva? [/quote] neyavvaa.... script pettali anna script task ni laagi use cheyyali gaa... atlaage DCT.... ya paina gazini cheppinattuuu not exists kusa kusa cheyyochuu... aina Q aduguthunnavaa!! soln telusukuntunnavaaa!!?
deals2buy Posted January 14, 2013 Report Posted January 14, 2013 [quote name='ghazni' timestamp='1358046667' post='1303099226'] undi mama edo nenu use chesa adi kani gurtu ravadam ledu.. its like not exists.... [/quote] subquery na? [quote name='mtkr' timestamp='1358048124' post='1303099325'] neyavvaa.... script pettali anna script task ni laagi use cheyyali gaa... atlaage DCT.... ya paina gazini cheppinattuuu not exists kusa kusa cheyyochuu... [b][color=#ff0000]aina Q aduguthunnavaa!! soln telusukuntunnavaaa!!?[/color][/b] [/quote]script oka daggara save chesukuni prati saari script task lo adi paste cheyyude ani telling [b][color=#ff0000]doubt clear chesukuntunna [/color][/b][img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img]
ghazni Posted January 14, 2013 Report Posted January 14, 2013 [quote name='Kaarthikeya' timestamp='1358126973' post='1303103677'] subquery na? [/quote] adi epatiko gani strike avadu..... i thought of using but i did not find the right reason used left join and where statement lo Null find peta.......
deals2buy Posted January 14, 2013 Report Posted January 14, 2013 [quote name='ghazni' timestamp='1358127232' post='1303103685'] adi epatiko gani strike avadu..... i thought of using but i did not find the right reason used left join and where statement lo Null find peta....... [/quote] ok...but Oracle lo minus laga SQL Server lo emaina unda ani eppati nundo
ghazni Posted January 14, 2013 Report Posted January 14, 2013 got it except and intersect http://www.simple-talk.com/sql/performance/the-except-and-intersect-operators-in-sql-server/
deals2buy Posted January 14, 2013 Report Posted January 14, 2013 [quote name='ghazni' timestamp='1358127323' post='1303103690'] got it except and intersect [url="http://www.simple-talk.com/sql/performance/the-except-and-intersect-operators-in-sql-server/"]http://www.simple-ta...-in-sql-server/[/url] [/quote] but idi Legacy SQL Server lo pani cheyyad ga
ghazni Posted January 14, 2013 Report Posted January 14, 2013 [quote name='Kaarthikeya' timestamp='1358127524' post='1303103700'] but idi Legacy SQL Server lo pani cheyyad ga [/quote] asalu aa legacy antey ento chepu.......... ipati varaku vinadam kani naku teliyadu..........
fake_Bezawada Posted January 14, 2013 Report Posted January 14, 2013 error 72001 idhi once solve chesa nenu anthaku minchi mysql em teliyadhu
bad__boy Posted January 14, 2013 Report Posted January 14, 2013 Bhayya, Sql Server 2008, SSIS, SSRS Videos and materials vuntee help cheyandhee plz plz......
deals2buy Posted January 14, 2013 Report Posted January 14, 2013 [quote name='ghazni' timestamp='1358127621' post='1303103707'] asalu aa legacy antey ento chepu.......... ipati varaku vinadam kani naku teliyadu.......... [/quote] SQL Server 2000 mama [quote name='fake_Bezawada' timestamp='1358163415' post='1303104793'] error 72001 idhi once solve chesa nenu anthaku minchi mysql em teliyadhu [/quote] idi mySQL kaadu...SQL server
Recommended Posts