Ms Sql Server Technology Discussions

[gundugadu]

[quote name='deals2buy' timestamp='1354203016' post='1302870895']
How many queries does the following code produce in an estimated execution plan?

Begin Transaction

SET QUOTED_IDENTIFIER ON;

SET ARITHABORT ON;

SET NUMERIC_ROUNDABORT OFF;

SET CONCAT_NULL_YIELDS_NULL ON;

SET ANSI_NULLS ON;

SET ANSI_PADDING ON;

SET ANSI_WARNINGS ON;

COMMIT
[/quote]

none

[Darling999]

[quote name='deals2buy' timestamp='1354211039' post='1302871934']
ya subquery kante case statement better anipistondi...but even though I find some duplicates

chudaali inkem possibilities unnayo
[/quote]

oka duplicates vastey aah case raasina sql lo from daggara table lo select distinct of table name raayi vastadi

Sel Case when this = 0 then 1 else 0 end
from (Select Distinct cols from table name ) this will eliminate dups

[deals2buy]

[quote name='gundugadu' timestamp='1354215095' post='1302872598']
none
[/quote]

nuvvu vaadedi SQL Server 2005 aa?
[quote name='DARLING...' timestamp='1354215286' post='1302872632']

oka duplicates vastey aah case raasina sql lo from daggara table lo select distinct of table name raayi vastadi

Sel Case when this = 0 then 1 else 0 end
from (Select Distinct cols from table name ) this will eliminate dups
[/quote]ya adi kuda try chesaanu..still konnitiki IDs different undatam valla unique ga raavatam ledu

[Darling999]

[quote name='deals2buy' timestamp='1354216144' post='1302872767']
nuvvu vaadedi SQL Server 2005 aa?
ya adi kuda try chesaanu..still konnitiki IDs different undatam valla unique ga raavatam ledu
[/quote]
avunaa may bee nuvveu choosey column unique lekapotey ala vastadi it happend to me in past

[deals2buy]

[quote name='DARLING...' timestamp='1354216521' post='1302872802']
avunaa may bee nuvveu choosey column unique lekapotey ala vastadi it happend to me in past
[/quote]
ya..but I still need to get only one..ade ela ani alochistunna inka..inthaki appudu nuvvu em chesav mari?

[Darling999]

[quote name='deals2buy' timestamp='1354216621' post='1302872818']
ya..but I still need to get only one..ade ela ani alochistunna inka..inthaki appudu nuvvu em chesav mari?
[/quote]

unique colum ttho join chestey vstaayi but ala kaakundaa one to many relation unna field tho join chestey kashtam raadu You have to show them the proof

[deals2buy]

[quote name='DARLING...' timestamp='1354216716' post='1302872831']

unique colum ttho join chestey vstaayi but ala kaakundaa one to many relation unna field tho join chestey kashtam raadu [b][color=#ff0000]You have to show them the proof[/color][/b]
[/quote]
what do you mean by that?

[Darling999]

[quote name='deals2buy' timestamp='1354216813' post='1302872847']
what do you mean by that?
[/quote]
adey dude, tell them of why you still get the Dups in a dataset due to lack of unique field ani.

see

col1 col2
1 1
1 1
1

Deeni meeda join chestey enni vastaayi results?

do a inner join, left join and right join. dont use pen n paper tell me or system.

[deals2buy]

[quote name='DARLING...' timestamp='1354216991' post='1302872871']
adey dude, tell them of why you still get the Dups in a dataset due to lack of unique field ani.

see

col1 col2
1 1
1 1
1

Deeni meeda join chestey enni vastaayi results?

do a inner join, left join and right join. dont use pen n paper tell me or system.
[/quote]
oh ok..alaa antaava? ya asalu ee data vache source lo ne tappu ani naa feeling..maree antha faalthu ga create cheyyaru kadaa data model..so, i'm now in the process of figuring out that

[deals2buy]

[b]
[url="http://www.sqlservercentral.com/blogs/sqlstudies/2012/11/26/creating-an-empty-table-from-a-select-statement/"]Creating an empty table from a SELECT statement[/url][/b]

[Desamudhuru]

[quote name='deals2buy' timestamp='1354286199' post='1302876925']

[b] [url="http://www.sqlservercentral.com/blogs/sqlstudies/2012/11/26/creating-an-empty-table-from-a-select-statement/"]Creating an empty table from a SELECT statement[/url][/b]
[/quote]

[mtkr]

[quote name='chelsea' timestamp='1354203100' post='1302870905']

na reqirement kada job search lo vunna andaru database design and data modeling aduguthunnaru
[/quote]

client anthaga em adagaru anukuntaa( in case dev job aithe)

vendor ki paina cheppinattu chesa ani cheppu mama....n paina mention chesinattu aa tools chudu okasarii...

ER model ante andulo 3 stages untai anukuntaa gaaa...(concuptional, physical, logical )(na mrktng appudu chusaaa)

[chelsea]

[quote name='mtkr' timestamp='1354323524' post='1302880934']
client anthaga em adagaru anukuntaa( in case dev job aithe)

vendor ki paina cheppinattu chesa ani cheppu mama....n paina mention chesinattu aa tools chudu okasarii...

ER model ante andulo 3 stages untai anukuntaa gaaa...(concuptional, physical, logical )(na mrktng appudu chusaaa)
[/quote]

hmm avuna ba naku client interview monday or tuesday vunnadi job description loekkava data modeling and ER model meda vunnadi so anduke ERWin tools use chestharu ani telusuu ba kani evvaru ayyina real time lo database design ela chesaru emo ani

[mtkr]

[quote name='chelsea' timestamp='1354323769' post='1302880940']
hmm avuna ba naku client interview monday or tuesday vunnadi job description loekkava data modeling and ER model meda vunnadi so anduke ERWin tools use chestharu ani telusuu ba kani evvaru ayyina real time lo database design ela chesaru emo ani
[/quote]
oh...k All the best mama...
deeni meedha?

n oka saari aaa sql discussion thread lo kuda post cheiii mama....

[KrishnaJai]