tag:blogger.com,1999:blog-7805972021499203804.post1880661047371875036..comments2023-10-30T06:24:14.411-07:00Comments on ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview: SQL Server Query to Delete Duplicate Records (Rows) from TableSuresh Dasarihttp://www.blogger.com/profile/01337689983379917267noreply@blogger.comBlogger17125tag:blogger.com,1999:blog-7805972021499203804.post-86747063724796397842013-09-12T02:50:35.737-07:002013-09-12T02:50:35.737-07:00I regular Visit Your Website And I Take Lot Of Use...I regular Visit Your Website And I Take Lot Of Use Things Here And Then Use It Own Website.<br />First Of All I Give Thanks To Your Efforts Regarding Your Help For New Comer In This Field.<br /> Anonymoushttps://www.blogger.com/profile/00111337390317741103noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-54852211874366303662013-08-11T00:27:12.071-07:002013-08-11T00:27:12.071-07:00we can use like this - delete emp-table where empi...we can use like this - delete emp-table where empid <br />in (select empid from emp-table group by empid having count(*)>1)Anonymoushttps://www.blogger.com/profile/06841661751828946745noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-4998560134434366402013-07-20T05:53:55.446-07:002013-07-20T05:53:55.446-07:00It's very useful for me ...........Thank u sur...It's very useful for me ...........Thank u sureshRavinth002noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-23313625687415308382013-07-12T03:47:19.109-07:002013-07-12T03:47:19.109-07:00sir can u pls tel me how to use WITH tempTable as(...sir can u pls tel me how to use WITH tempTable as() function in c# codeAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-46717959345157900552013-06-28T21:53:32.781-07:002013-06-28T21:53:32.781-07:00Every time i read your blocks sir they are really ...Every time i read your blocks sir they are really usefull for me .........thanks a lot bossPankaj Sharmahttps://www.blogger.com/profile/17373194213068974020noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-91920210088143749252013-06-04T09:10:56.735-07:002013-06-04T09:10:56.735-07:00Respected Sir,
can u tell me the best books for as...Respected Sir,<br />can u tell me the best books for asp.net and sqlserver2012.<br />Anonymoushttps://www.blogger.com/profile/08939200966392918420noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-24397683265171980712013-05-20T11:55:08.253-07:002013-05-20T11:55:08.253-07:00AWESOME!!!!! Thanks a lot. AWESOME!!!!! Thanks a lot. Andréhttps://www.blogger.com/profile/03464579647195623917noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-29717199323624724152013-05-14T06:03:15.503-07:002013-05-14T06:03:15.503-07:00I don't know how to remove my date to SQL serv...I don't know how to remove my date to SQL server?Archiveshttp://www.hermesstyles.comnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-34184692379379043062013-04-15T09:05:36.397-07:002013-04-15T09:05:36.397-07:00Dear Suresh, Is that only way to find duplicate re...Dear Suresh, Is that only way to find duplicate record and delete them and is that Optimized query?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-10111116272037581822012-12-21T03:43:44.341-08:002012-12-21T03:43:44.341-08:00Recently I had a question in interview as follows ...Recently I had a question in interview as follows <br /><br />For example my name is Dorababu some of them inserted as Dorababu,Dhorababu and dorebabu like this. I would like to delete the remaining except Dorababu from the table how can I do thisDorababuhttps://www.blogger.com/profile/08685478436586902404noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-82569745029701861732012-12-03T10:21:05.105-08:002012-12-03T10:21:05.105-08:00You are awesome - Very very helpfulYou are awesome - Very very helpfulAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-25937321077704709272012-07-10T09:26:01.252-07:002012-07-10T09:26:01.252-07:00Got it....!!!!!Got it....!!!!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-10120027515124662582012-07-10T09:08:20.831-07:002012-07-10T09:08:20.831-07:00I just created a table like u had. Then i ran the ...I just created a table like u had. Then i ran the above mentiones query in query browser in SQL Server. The output i got is Invalid column name 'RowNumber. Can you explain this. I havent taken any datatable. i just executed the queryAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-13099510840327195522012-07-09T21:17:55.455-07:002012-07-09T21:17:55.455-07:00Here i taken RowNumber as a just columnname to dis...Here i taken RowNumber as a just columnname to display result of count i hope you made it as separate column with datatable. please check the query what i written...Suresh Dasarihttps://www.blogger.com/profile/01337689983379917267noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-46154806126205495382012-07-09T20:22:03.707-07:002012-07-09T20:22:03.707-07:00Hi Suresh.. when i execute this query in sql serve...Hi Suresh.. when i execute this query in sql server it gives me an error :- "Invalid column name 'RowNumber'."<br /><br />Can you Please help...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-35314182784128831142012-05-19T00:02:52.376-07:002012-05-19T00:02:52.376-07:00hi MR.suresh i want to know About Insteller class ...hi MR.suresh i want to know About Insteller class can u please give the demo on that u r site is so good and usefull please continue posting thank usrinivashttps://www.blogger.com/profile/12047864059452624732noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-38167768101973545982012-05-19T00:00:03.889-07:002012-05-19T00:00:03.889-07:00hi MR.suresh i want to know About Insteller class ...hi MR.suresh i want to know About Insteller class can u please give the demo on that u r site is so good and usefull please continue posting thank usrinivashttps://www.blogger.com/profile/12047864059452624732noreply@blogger.com