No announcements
Found 759130 threads
-
1 VotesMS Access - Deleting duplicated rows
Ciao Ragazzi, So far coudn't find a way to solve this problem on deleting duplicated rows on an MS Access 2010 table ...Answered | 4 Replies | 501 Views | Created by H Souza - Thursday, December 17, 2015 3:31 AM | Last reply by Paul23 - Saturday, December 19, 2015 2:05 PM
-
0 Votes
duplicated rows
Thanks, this helps a lot. It seems I need to mark all other rows as NotMin. Is there a way to mark all the other duplicated rows as SET f5 = 'NotMinimum' ...Answered | 3 Replies | 6214 Views | Created by xyz_999 - Wednesday, July 5, 2006 9:54 PM | Last reply by xyz_999 - Thursday, July 6, 2006 1:52 AM -
0 Votes
removing duplicated rows
Hi, Need to remove the duplicated rows from a table which has text/ntext/image type columns. The table does not have any PK/Unique column. (I accept its a bad data model). But ...Answered | 1 Replies | 7431 Views | Created by smith_a - Friday, December 2, 2005 9:58 AM | Last reply by - Friday, December 2, 2005 2:01 PM -
0 Votes
Duplicated Rows
with my stored procedure is that I get duplicate rows in my results. The row is a duplicate in terms of column 'Job No' as when the query runs in access only one instance of each ...Unanswered | 2 Replies | 7173 Views | Created by Aston35 - Tuesday, October 31, 2006 11:02 AM | Last reply by Aston35 - Tuesday, October 31, 2006 12:16 PM -
3 Votes
Deleting Sharepoint Lists published through MS Access
attempt to delete a SharePoint List, it states that there is a relationship to another list/table which prevents me from deleting any of the SharePoint Lists. Is ...Answered | 1 Replies | 8491 Views | Created by vs2015junkie - Monday, March 19, 2012 8:23 PM | Last reply by Gutke - Monday, March 19, 2012 9:23 PM -
0 Votes
Won't see duplicated rows.
2000 Cash 2000 They are duplicated. I only want to show one row.Unanswered | 4 Replies | 3121 Views | Created by ardmore - Friday, December 5, 2008 8:09 PM | Last reply by Jerzy Doskocz (pen_2) - Monday, December 8, 2008 10:08 PM -
0 Votes
Removing Duplicated rows
Hello, Here is a few methods for removing duplicate records from a sql table http://www.kodyaz.com/articles/delete-duplicate-records-rows-in-a-table.aspx. You can ...Answered | 5 Replies | 5395 Views | Created by SQL_1980 - Wednesday, May 25, 2011 10:24 AM | Last reply by eralper - Wednesday, May 25, 2011 10:37 AM -
0 Votes
Deleting Rows
its simple dear..if u open ur applicaion again new dataset wil b loaded n same query wil b fired n database wil return acc to then query.. u r deleting rows ...Answered | 1 Replies | 2616 Views | Created by ChrisMoje - Wednesday, March 21, 2007 6:29 AM | Last reply by Jay_Vora_b4843e - Wednesday, March 21, 2007 8:21 AM -
0 Votes
Deleting Rows
associated with each file. Some of these files were found in the \temporary internet files\ folder on the systems ...Answered | 2 Replies | 4907 Views | Created by mattw112 - Monday, April 21, 2008 10:47 PM | Last reply by TheSQLGuru - Monday, April 21, 2008 11:23 PM -
1 Votes
Why rows are duplicated for a Table?
would post the script, we can probably tell you what is wrong. 1. Duplicated rows mean that you are missing a unique or primary key constraint. ...Answered | 1 Replies | 7641 Views | Created by Wonjartran - Friday, March 5, 2010 7:10 PM | Last reply by Louis Davidson - Friday, March 5, 2010 10:54 PM -
0 Votes
deleting rows
If dsIncident.Tables(0).Rows.Count > 0 Then dsIncident.Tables(0).Rows(0).Delete() da.Update(dsIncident.Tables(0)) End IfAnswered | 5 Replies | 979 Views | Created by Ron399 - Sunday, May 26, 2013 11:50 AM | Last reply by Dan Guzman - Sunday, May 26, 2013 12:42 PM -
0 Votes
Insert avoiding duplicated rows
I need to insert into a table (TBL1) from another table (TBL2) that could contain some duplicates for the primary key of the first table (TBL1), but I want to do it without a stored procedure ...Answered | 14 Replies | 3535 Views | Created by pscorca - Tuesday, January 26, 2010 5:55 PM | Last reply by Naomi N - Wednesday, January 27, 2010 5:11 AM -
0 Votes
Delete the duplicated rows.
2 Is it correct?Answered | 3 Replies | 3771 Views | Created by ardmore - Tuesday, January 13, 2009 10:56 PM | Last reply by Aaron Alton - Wednesday, January 14, 2009 3:55 AM -
0 Votes
Deleting Rows VBA
Forgive me for being a complete beginner but i am looking for the most efficient way of looping through each sheet in my workbook and deleting the first 8 ...Answered | 1 Replies | 429 Views | Created by _steve p - Thursday, October 31, 2013 8:24 AM | Last reply by Hans Vogelaar MVP - Thursday, October 31, 2013 10:32 AM -
2 Votes
SQL 2012 - Latin1_General_100_CS_AS_SC - Unicode character - duplicated rows
Hi My table include 24428 rows with Unicode characterAnswered | 4 Replies | 5301 Views | Created by MyRBC - Wednesday, August 15, 2012 6:44 PM | Last reply by MyRBC - Thursday, August 16, 2012 1:30 PM -
1 Votes
need help with access query - removing duplicated rows
how to delete duplicated rows - but leave only the firs row ?Answered | 5 Replies | 3388 Views | Created by E_gold - Tuesday, January 19, 2010 4:36 PM | Last reply by Naomi N - Tuesday, January 19, 2010 5:57 PM -
0 Votes
Deleting a Table from Database (MS Access)
Dear Richard, Thanks for the tips! Indeed I am making a transition from MS Access to C#. As there are old programs and database developed in MS ...Answered | 8 Replies | 3574 Views | Created by edwardlee007 - Friday, May 29, 2015 3:47 PM | Last reply by kumar visakhapatnam - Saturday, May 30, 2015 6:58 AM -
0 Votes
Windows Mobile datagrid deleting rows
Hi experts, I am developing Windows mobile application and i had to use the ...Answered | 2 Replies | 4660 Views | Created by Britekumar - Friday, March 27, 2009 2:54 AM | Last reply by Malleswara Reddy [MCTS, MCP] - Monday, March 30, 2009 8:17 AM -
0 Votes
Deleting Rows in DataGridView
Hi, I don't know why you want to use the event. Deleting rows by hitting the Del key is a buildin feature of the ...Answered | 3 Replies | 3192 Views | Created by curious_12 - Sunday, March 16, 2008 1:35 AM | Last reply by Philipp Merz - Sunday, March 16, 2008 2:07 PM -
0 Votes
Count None Duplicated Rows from DataGrideView
hi, I have a DataGrideView that displays the passengers on different flight numbers. I need to count only the number of flights which will be duplicated in my ...Unanswered | 3 Replies | 517 Views | Created by Hassan Maskeen - Saturday, November 30, 2013 7:36 AM | Last reply by Terrence-Jones - Thursday, December 5, 2013 1:22 PM - Items 1 to 20 of 759130 Next ›
No announcements
