mtkr Posted October 16, 2012 Report Posted October 16, 2012 /////////////[color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]nuvvu oka table ne delete cheyyadam cheptunnav ga ee example lo////////////////[/background][/size][/font][/color] no aa ex lo rendu tbls lo data del avutundhiii(???)[color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] [/background][/size][/font][/color]
cherlapalli_jailer Posted October 16, 2012 Report Posted October 16, 2012 delete fronm tbla a ,rblb b , tblc c where a.id = b.id and b.id=c.id ani try ccheyyavachhu
mtkr Posted October 16, 2012 Report Posted October 16, 2012 [quote name='cherlapalli_jailer' timestamp='1350426448' post='1302639731'] My point is also same so he has to confirm .... [/quote] same track
mtkr Posted October 16, 2012 Report Posted October 16, 2012 [quote name='deals2buy' timestamp='1350426605' post='1302639744'] ippudu multiple tables nundi data teesukochi oka table ki ela delete cheyyocho single statement use chesi ala delete cheyyalevu antunna single statement lo [/quote]
deals2buy Posted October 16, 2012 Report Posted October 16, 2012 [quote name='mtkr' timestamp='1350426646' post='1302639748'] /////////////[color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]nuvvu oka table ne delete cheyyadam cheptunnav ga ee example lo////////////////[/background][/size][/font][/color] no aa ex lo rendu tbls lo data del avutundhiii(???)[color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] [/background][/size][/font][/color] [/quote] athani previous statement lo aithe okate table nudni avutayi naaku telisi..endukante delete from ani okate table mention chesadu kabatti ee kindadi work avutundo ledo example try cheste kaani teleedy [quote name='cherlapalli_jailer' timestamp='1350426721' post='1302639755'] delete fronm tbla a ,rblb b , tblc c where a.id = b.id and b.id=c.id ani try ccheyyavachhu [/quote]
ghazni Posted October 22, 2012 Author Report Posted October 22, 2012 [color=#282828][font=helvetica, arial, sans-serif]1[/font][/color][color=#b22222][font=helvetica, arial, sans-serif]. Just run the where clause and make sure it is fetching the records that you want to delete[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]yeah rasindey where clause first...... so adi good.... [/font][/color] [color=#b22222][font=helvetica, arial, sans-serif]2. From your pm you said oka table lo data delete avutundi annav..you want to delete data from two tables at a time?[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]oka 7 tables unayi so ani joins use chesanu..... oka table peti delete chesanukoni rows affect ayayi... aa joins lo nunchi inko table teesi delete lo peta.... apudu 0 rows affected ani vachindi..... I think ani tables oaktey sari delete kavemo kada.........[/font][/color]
ChampakDas Posted October 22, 2012 Report Posted October 22, 2012 Cool so there's no problem with the clause logic.. second point di with table and moving that table to join two difference ekada paste chesthava that will be easy.. yes, you are right we cannot delete sequential order lo undali but if there is realtion between those two tables that you wanted to delete then you can make use of OUTPUT deleted table.. [quote name='ghazni' timestamp='1350948161' post='1302673097'] [color=#282828][font=helvetica, arial, sans-serif]1[/font][/color][color=#b22222][font=helvetica, arial, sans-serif]. Just run the where clause and make sure it is fetching the records that you want to delete[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]yeah rasindey where clause first...... so adi good.... [/font][/color] [color=#b22222][font=helvetica, arial, sans-serif]2. From your pm you said oka table lo data delete avutundi annav..you want to delete data from two tables at a time?[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]oka 7 tables unayi so ani joins use chesanu..... oka table peti delete chesanukoni rows affect ayayi... aa joins lo nunchi inko table teesi delete lo peta.... apudu 0 rows affected ani vachindi..... I think ani tables oaktey sari delete kavemo kada.........[/font][/color] [/quote]
ghazni Posted October 22, 2012 Author Report Posted October 22, 2012 [color=#282828][color=#0000FF][font=arial, sans-serif][size=3]DELETE[/size][/font][font=helvetica, arial, sans-serif] [/font][/color][/color][color=#282828][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]H [/size][/font][color=#0000FF][font=arial, sans-serif][size=3]FROM[/size][/font][/color][font=arial, sans-serif][size=3] LCMSDWData[/size][/font][color=#808080][font=arial, sans-serif][size=3].[/size][/font][/color][font=arial, sans-serif][size=3]DWDimHearing H[/size][/font][/size][/font][/color] [color=#808080][font=arial, sans-serif][size=3]INNER[/size][/font][/color][font=helvetica, arial, sans-serif][color=#282828] [/color][/font][color=#282828][font=helvetica, arial, sans-serif][size=1][color=#808080][font=arial, sans-serif][size=3]JOIN[/size][/font][/color][font=arial, sans-serif][size=3] LCMSDWData[/size][/font][color=#808080][font=arial, sans-serif][size=3].[/size][/font][/color][font=arial, sans-serif][size=3]DWDimCase DC [/size][/font][color=#0000FF][font=arial, sans-serif][size=3]ON[/size][/font][/color][/size][/font][/color] [color=#282828][font=arial, sans-serif][size=3]DC[/size][/font][font=helvetica, arial, sans-serif] [/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=1][color=#808080][font=arial, sans-serif][size=3].[/size][/font][/color][font=arial, sans-serif][size=3]APPCODE [/size][/font][color=#808080][font=arial, sans-serif][size=3]=[/size][/font][/color][font=arial, sans-serif][size=3] H[/size][/font][color=#808080][font=arial, sans-serif][size=3].[/size][/font][/color][font=arial, sans-serif][size=3]APPCODE[/size][/font][/size][/font][/color] [color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]AND[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3] DC[/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3].[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3]CMSCASE [/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]=[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3] H[/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3].[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3]CMSCASE[/size][/size][/font][/color] [color=#808080][font=arial, sans-serif][size=3]INNER[/size][/font][/color][font=helvetica, arial, sans-serif][color=#282828] [/color][/font][color=#282828][font=helvetica, arial, sans-serif][size=1][color=#808080][font=arial, sans-serif][size=3]JOIN[/size][/font][/color][font=arial, sans-serif][size=3] LCMSDWData[/size][/font][color=#808080][font=arial, sans-serif][size=3].[/size][/font][/color][font=arial, sans-serif][size=3]DWDimHearingData HD [/size][/font][color=#0000FF][font=arial, sans-serif][size=3]ON[/size][/font][/color][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]DC[/size][/font][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=1][color=#808080][font=arial, sans-serif][size=3].[/size][/font][/color][font=arial, sans-serif][size=3]APPCODE [/size][/font][color=#808080][font=arial, sans-serif][size=3]=[/size][/font][/color][font=arial, sans-serif][size=3] HD[/size][/font][color=#808080][font=arial, sans-serif][size=3].[/size][/font][/color][font=arial, sans-serif][size=3]APPCODE[/size][/font][/size][/font][/color] [color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]AND[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3] DC[/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3].[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3]CMSCASE [/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]=[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3] HD[/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3].[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3]CMSCASE[/size][/size][/font][/color] [color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]AND[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3] DC[/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3].[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3]CASENBR [/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]=[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3] HD[/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3].[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3]LCMSCaseNumber[/size][/size][/font][/color] [color=#b22222][font=arial, sans-serif][size=3]INNER[/size][/font][font=helvetica, arial, sans-serif] [/font][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]JOIN LCMSDWData.DWDimLegalActionEvent LAE [/size][/font][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=1][color=#0000FF][font=arial, sans-serif][size=3]ON[/size][/font][/color][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]H[/size][/font][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=1][color=#808080][font=arial, sans-serif][size=3].[/size][/font][/color][font=arial, sans-serif][size=3]APPCODE [/size][/font][color=#808080][font=arial, sans-serif][size=3]=[/size][/font][/color][font=arial, sans-serif][size=3] LAE[/size][/font][color=#808080][font=arial, sans-serif][size=3].[/size][/font][/color][font=arial, sans-serif][size=3]APPCODE[/size][/font][/size][/font][/color] [color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]AND[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3] H[/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3].[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3]CMSCASE [/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]=[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3] LAE[/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3].[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3]ACTNCSE[/size][/size][/font][/color] [color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]AND[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3] H[/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3].[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3]CMSEvent [/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]=[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3] LAE[/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3].[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3]CMSEvent[/size][/size][/font][/color] [color=#282828][font=arial, sans-serif][size=3]next[/size][/font][/color] [color=#b22222][font=arial, sans-serif][size=3]DELETE[/size][/font][font=helvetica, arial, sans-serif] LAE [/font][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3] FROM [/size][/font][/size][/font][font=arial, sans-serif][size=1][size=3] LCMSDWData[/size][/size][/font][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3].[/size][/font][/size][/font][font=arial, sans-serif][size=1][size=3]DWDimLegalActionEvent LAE[/size][/size][/font][/color] [color=#808080][font=arial, sans-serif][size=3]INNER[/size][/font][/color][font=helvetica, arial, sans-serif][color=#282828] [/color][/font][color=#282828][font=helvetica, arial, sans-serif][size=1][color=#808080][font=arial, sans-serif][size=3]JOIN[/size][/font][/color][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3] LCMSDWData[/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3].[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3]DWDimHearing H[/size][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3] [/size][/size][/font][/color][color=#0000FF][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]ON[/size][/font][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]H[/size][/font][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=1][color=#808080][font=arial, sans-serif][size=3].[/size][/font][/color][font=arial, sans-serif][size=3]APPCODE [/size][/font][color=#808080][font=arial, sans-serif][size=3]=[/size][/font][/color][font=arial, sans-serif][size=3] LAE[/size][/font][color=#808080][font=arial, sans-serif][size=3].[/size][/font][/color][font=arial, sans-serif][size=3]APPCODE[/size][/font][/size][/font][/color] [color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]AND[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3] H[/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3].[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3]CMSCASE [/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]=[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3] LAE[/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3].[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3]ACTNCSE[/size][/size][/font][/color] [color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]AND[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3] H[/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3].[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3]CMSEvent [/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]=[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3] LAE[/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3].[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3]CMSEvent[/size][/size][/font][/color] [color=#808080][font=arial, sans-serif][size=3]INNER[/size][/font][/color][font=helvetica, arial, sans-serif][color=#282828] [/color][/font][color=#282828][font=helvetica, arial, sans-serif][size=1][color=#808080][font=arial, sans-serif][size=3]JOIN[/size][/font][/color][font=arial, sans-serif][size=3] LCMSDWData[/size][/font][color=#808080][font=arial, sans-serif][size=3].[/size][/font][/color][font=arial, sans-serif][size=3]DWDimCase DC [/size][/font][color=#0000FF][font=arial, sans-serif][size=3]ON[/size][/font][/color][/size][/font][/color] [color=#282828][font=arial, sans-serif][size=3]DC[/size][/font][font=helvetica, arial, sans-serif] [/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=1][color=#808080][font=arial, sans-serif][size=3].[/size][/font][/color][font=arial, sans-serif][size=3]APPCODE [/size][/font][color=#808080][font=arial, sans-serif][size=3]=[/size][/font][/color][font=arial, sans-serif][size=3] H[/size][/font][color=#808080][font=arial, sans-serif][size=3].[/size][/font][/color][font=arial, sans-serif][size=3]APPCODE[/size][/font][/size][/font][/color] [color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]AND[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3] DC[/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3].[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3]CMSCASE [/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]=[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3] H[/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3].[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3]CMSCASE[/size][/size][/font][/color] [color=#808080][font=arial, sans-serif][size=3]INNER[/size][/font][/color][font=helvetica, arial, sans-serif][color=#282828] [/color][/font][color=#282828][font=helvetica, arial, sans-serif][size=1][color=#808080][font=arial, sans-serif][size=3]JOIN[/size][/font][/color][font=arial, sans-serif][size=3] LCMSDWData[/size][/font][color=#808080][font=arial, sans-serif][size=3].[/size][/font][/color][font=arial, sans-serif][size=3]DWDimHearingData HD [/size][/font][color=#0000FF][font=arial, sans-serif][size=3]ON[/size][/font][/color][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]DC[/size][/font][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=1][color=#808080][font=arial, sans-serif][size=3].[/size][/font][/color][font=arial, sans-serif][size=3]APPCODE [/size][/font][color=#808080][font=arial, sans-serif][size=3]=[/size][/font][/color][font=arial, sans-serif][size=3] HD[/size][/font][color=#808080][font=arial, sans-serif][size=3].[/size][/font][/color][font=arial, sans-serif][size=3]APPCODE[/size][/font][/size][/font][/color] [color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]AND[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3] DC[/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3].[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3]CMSCASE [/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]=[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3] HD[/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3].[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3]CMSCASE[/size][/size][/font][/color] [color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]AND[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3] DC[/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3].[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3]CASENBR [/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]=[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3] HD[/size][/size][/font][/color][color=#808080][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3].[/size][/font][/size][/font][/color][color=#282828][font=arial, sans-serif][size=1][size=3]LCMSCaseNumber[/size][/size][/font][/color] [color=#282828][font=arial, sans-serif][size=1][size=3]ala just inter change chesa..... next query ki 0 rows affected ani vachindi.......[/size][/size][/font][/color]
ChampakDas Posted October 22, 2012 Report Posted October 22, 2012 oka fundamental doubt aliasing marchav kada second query lo?
ghazni Posted October 22, 2012 Author Report Posted October 22, 2012 [quote name='ChampakDas' timestamp='1350949468' post='1302673214'] oka fundamental doubt aliasing marchav kada second query lo? [/quote] yeah adi cover chesa mama......... adi run ayindi query kani 0 rows affected ani vachindi...
ChampakDas Posted October 23, 2012 Report Posted October 23, 2012 mama reply..edhi aithe I will jump [img]http://i29.tinypic.com/33oo7pg.gif[/img]
ChampakDas Posted October 23, 2012 Report Posted October 23, 2012 cool adhey mama reason...if there are no records in the source table all you get is 0 records affected. Ok now whats the best solution: keep track of the deleted records like this [color=#282828][color=#0000FF][font=arial, sans-serif][size=3]DELETE[/size][/font][font=helvetica, arial, sans-serif] [/font][/color][/color][color=#282828][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]H [/size][/font][color=#0000FF][font=arial, sans-serif][size=3]FROM[/size][/font][/color][font=arial, sans-serif][size=3] LCMSDWData[/size][/font][color=#808080][font=arial, sans-serif][size=3].[/size][/font][/color][font=arial, sans-serif][size=3]DWDimHearing H[/size][/font][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]OUTPUT DELETED.Somecolumn -- deleted here will be the temp table...ela chesthey at this step we will delete the records from the table and also keep track of id's which we can use to delete in the subsequent tables...[/size][/font][/size][/font][/color]
ghazni Posted October 23, 2012 Author Report Posted October 23, 2012 [quote name='ChampakDas' timestamp='1350951352' post='1302673408'] cool adhey mama reason...if there are no records in the source table all you get is 0 records affected. Ok now whats the best solution: keep track of the deleted records like this [color=#282828][color=#0000FF][font=arial, sans-serif][size=3]DELETE[/size][/font][font=helvetica, arial, sans-serif] [/font][/color][/color][color=#282828][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]H [/size][/font][color=#0000FF][font=arial, sans-serif][size=3]FROM[/size][/font][/color][font=arial, sans-serif][size=3] LCMSDWData[/size][/font][color=#808080][font=arial, sans-serif][size=3].[/size][/font][/color][font=arial, sans-serif][size=3]DWDimHearing H[/size][/font][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=1][font=arial, sans-serif][size=3]OUTPUT DELETED.Somecolumn -- deleted here will be the temp table...ela chesthey at this step we will delete the records from the table and also keep track of id's which we can use to delete in the subsequent tables...[/size][/font][/size][/font][/color] [/quote] i will try this kani mari verey tables lo reecords delete cheyali antey we have to find child table kada......
ChampakDas Posted October 23, 2012 Report Posted October 23, 2012 office ki velli mari try chusava endhi...inka child table tho avasaram ledhu mama...because we know the ids(some column) on which we need to delete.. [quote name='ghazni' timestamp='1350958205' post='1302674163'] i will try this kani mari verey tables lo reecords delete cheyali antey we have to find child table kada...... [/quote]
ghazni Posted October 23, 2012 Author Report Posted October 23, 2012 [quote name='ChampakDas' timestamp='1350958467' post='1302674199'] office ki velli mari try chusava endhi...inka child table tho avasaram ledhu mama...because we know the ids(some column) on which we need to delete.. [/quote] i did not get it mama what you said........ aina aa output anedi ekada petali.....
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
Recommended Posts