gundugadu Posted November 29, 2012 Report Posted November 29, 2012 [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 Posted November 29, 2012 Report Posted November 29, 2012 [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 Posted November 29, 2012 Report Posted November 29, 2012 [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 Posted November 29, 2012 Report Posted November 29, 2012 [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 Posted November 29, 2012 Report Posted November 29, 2012 [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 Posted November 29, 2012 Report Posted November 29, 2012 [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 Posted November 29, 2012 Report Posted November 29, 2012 [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 Posted November 29, 2012 Report Posted November 29, 2012 [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 Posted November 29, 2012 Report Posted November 29, 2012 [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 Posted November 30, 2012 Report Posted November 30, 2012 [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 Posted November 30, 2012 Report Posted November 30, 2012 [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 Posted December 1, 2012 Report Posted December 1, 2012 [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 Posted December 1, 2012 Report Posted December 1, 2012 [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 Posted December 1, 2012 Report Posted December 1, 2012 [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....
Recommended Posts