Ms Sql Server Technology Discussions

[deals2buy]

How you find records that exist in one table and do not exist in another table?

[mtkr]

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

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

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

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

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

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

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

got it except and intersect

http://www.simple-talk.com/sql/performance/the-except-and-intersect-operators-in-sql-server/

[deals2buy]

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

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

[CrazyBoys]

Nice Post

[fake_Bezawada]

error 72001 idhi once solve chesa nenu anthaku minchi mysql em teliyadhu

[bad__boy]

Bhayya,

Sql Server 2008, SSIS, SSRS Videos and materials vuntee help cheyandhee plz plz......

[deals2buy]

[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