Questions tagged [duplicate-data]
354 questions
5
votes
4 answers
SQL Remove almost duplicate rows
I have a table that contains unfortuantely bad data and I'm trying to filter some out. I am sure that the LName, FName combonation is unique since the data set is small enough to verify.
LName, FName, Email
----- ----- -----
Smith Bob …
jmmr
- 498
- 7
- 17
5
votes
2 answers
What is the fastest way / script to duplicate visual studio project?
Hello
I have setup visual studio express c++ project, with paths to included headers and libs
Now I like to duplicate this project to be with the same paths to included headers and libs
But with different name , I don’t what to go manually into…
user63898
- 29,839
- 85
- 272
- 514
5
votes
1 answer
How to make duplicate sections in ELF file
I have a requirement where I need to create a duplicate/copy section of .data section.
I've tried creating a dummy section with same size of data section in linker script and copy the contents of data section to the dummy section in the init…
vimal prathap
- 411
- 7
- 17
5
votes
1 answer
Forward a copy of http requests to another (test) environment
I want all the production data for my web-app to also flow through my testing environment. Essentially, I want to forward every http request for the production site to the test site (and also have the production website serve it!).
What is a good…
raviv
- 205
- 4
- 9
5
votes
3 answers
Is it possible for SQL to find records with duplicates?
Can I use a SQL query to find records where one field is identical in both? That is, can I use the following table and return 1,3 (the ids) by comparing the name columns (and ignoring the phone)?
ID | Name | Phone
1 | Bob | 5555555555
…
waiwai933
- 14,133
- 21
- 62
- 86
5
votes
4 answers
Why stl map inserts another value if key already exist, and not just change it?
Why does my program using STL maps insert values when keys already exist instead of changing the existing values?
#include
#include
Yiin
- 659
- 6
- 9
5
votes
1 answer
I would like to understand a Microsoft Access wizard-generated query
Suppose I have a table named tbl_med, which has six fields: [nom_lab], [nom_desc], [nom_apres], [date_vig], [cod_med], [vr_pmc].
I want an MS Access SQL query that will:
Find duplicated records in relation to four of the fields: [nom_lab],…
NatBr
- 53
- 4
4
votes
2 answers
Using grep with a pattern file: print single and duplicate entries
Let me start off by saying I don't want to print only the duplicate lines nor do I want to remove them.
I am trying to use grep with a pattern file to parse a large data file.
The Pattern file for example may look like…
PlutonicFriend
- 79
- 1
- 9
4
votes
3 answers
CoreData - Duplicate existing object
Hi would like to duplicate an object from my core data db. Right now I'm using
movement2 = [NSEntityDescription
insertNewObjectForEntityForName:@"Movement"
…
Abramodj
- 5,709
- 9
- 49
- 75
4
votes
2 answers
duplicate data insert in CodeIgniter
I am just inserting data in codeigniter controller part at pastebin http://pastebin.com/KBtqrAkZ
public function add_product()
{
$this->lang->load('log_in', 'english');
log_in_check($this->lang->line('log_in_authentication_error'),…
ARIF MAHMUD RANA
- 5,026
- 3
- 31
- 58
4
votes
7 answers
Compare many text files that contain duplicate "stubs" from the previous and next file and remove duplicate text automatically
I have a large number of text files (1000+) each containing an article from an academic journal. Unfortunately each article's file also contains a "stub" from the end of the previous article (at the beginning) and from the beginning of the next…
fdsayre
- 175
- 2
- 11
4
votes
4 answers
SQL Server duplicate removal with a twist
SQL Server 2008, I have inherited a table like this (74k rows):
create table #mess (keycol char(36) , name1 varchar(254) , name2 varchar(254), valuex varchar(254) )
insert into #mess values ('971EC307-8514-450D-AE3A-4E25EA3F3A10' , 'a' , '' , ''…
Snowy
- 5,942
- 19
- 65
- 119
4
votes
3 answers
Avoiding duplicate-content hit on Google for archive pages?
Each blog post on my site -- http://www.correlated.org -- is archived at its own permalinked URL.
On each of these archived pages, I'd like to display not only the archived post but also the 10 posts that were published before it, so that people can…
jawns317
- 1,726
- 2
- 17
- 26
4
votes
2 answers
TDD duplication of test data
I'm new to test driven development and first time I'm tring to use it in a simple project.
I have a class, and I need to test creation, insertion and deletion of objects of this class. If I write three seperate test functions I need to duplicate…
metdos
- 13,411
- 17
- 77
- 120
4
votes
1 answer
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
This can be marked as duplicate but I am finding issue when I refereed
Create Unqiue case-insensitive constraint on two varchar fields
I have a table std_tbl having some duplicate records in one of the columns say Column_One.
I created a unique…
Microsoft DN
- 9,706
- 10
- 51
- 71