Stack Overflow
Stack Overflow

Questions tagged [no-duplicates]

70 questions
1
vote
1 answer

How do I generate random numbers from a column, without duplicates - SQL Server

I have a Profile table with columns: UserID, Firstname, Lastname I am trying create a stored procedure which passes in a @UserID parameter, and generates 10 random numbers taken from the UserID column. The aim of this is to allow one user to send a…
TreasaNGC
  • 62
  • 1
  • 10
1
vote
3 answers

Multiple wordpress loops for custom post type & taxonomy with no duplicates

I'm trying to make a custom template to display multiple loops from the same custom post type, but different categories. Here's what I am after: From custom post type: 'Portfolio' In custom category 1 'Music': 1 featured post at top Music Heading 3…
AJ1
  • 84
  • 1
  • 12
1
vote
6 answers

C# Check Object Array For Duplicates

I have an array of Customer[] objects, and I want to use it to create a Dictionary. What is the easiest way to examine the array for duplicates before I load the Dictionary? I want to avoid "ArgumentException: An item with the…
Jack T. Colton
  • 11
  • 1
  • 2
1
vote
2 answers

Selecting with preference in SQL Server

I have a table in SQL Server 2000 with data similar to the following: ReferenceNumber ReferenceValue 00001 Not assigned 00002 Not assigned 00002 ABCDE in which each ReferenceNumber can appear multiple times…
taserian
  • 624
  • 6
  • 17
1
vote
3 answers

MySQL Select if field is unique or null

Sorry, I can't find an example anywhere, mainly because I can't think of any other way to explain it that doesn't include DISTINCT or UNIQUE (which I've found to be misleading terms in SQL). I need to select unique values AND null values from one…
BenR
  • 13
  • 3
0
votes
1 answer

Batch filter duplicate lines and write to a new file (semi-finished)

I have successfully made a script that filters out duplicate lines in a file and saves the results to a variable semi-colon separated (sort of an "array"). I could not find any real good solution to it. @echo off setlocal enabledelayedexpansion rem…
Niklas J. MacDowall
  • 673
  • 13
  • 27
0
votes
2 answers

Is there a way to check for Duplicates when Importing Excel Sheet into MySQL table using vb.net

I have a upload excel file on my web application. When the file is uploaded it is supposed to be openned and then import the data into a mysql table. It works fine in that it adds the information just fine. However there is a problem the code I…
Skindeep2366
  • 1,549
  • 3
  • 41
  • 68
0
votes
3 answers

Python: Unexpected ordering in lists

I've encountering a weird behavior while working with lists in Python. I've implemented a method that returns a list of lists of Integers; in particular, those are cycles within a graph each including three nodes: simple_cycles =…
labrassbandito
  • 535
  • 12
  • 25
0
votes
4 answers

How to remove duplicate items from a queue within a time frame?

I would like to remove duplicate entries from a queue in an efficient way. The queue has a custom class with DateTime and FullPath and a few other things private Queue SharedQueue; The DateTime in the class is the timestamp when…
user610064
  • 481
  • 2
  • 11
  • 25
0
votes
2 answers

sort an $array of ints by repetition and remove repetitions

i need to do this in php lets say i have [1,1,1,1,1,1,1,1,1,1,1,1,1,1,2,3,4,5,5,5,5,5,5,5,5,5,5,5,9,9,9,9,9] i would like [1,5,9,2,3,4] but my situation its a bit different, it's result from a mysql query i have only an asociative atribute…
Toni Michel Caubet
  • 19,333
  • 56
  • 202
  • 378
0
votes
1 answer

Duplicate List records

How do I avoid entering the same kind of data from the same users in sharepoint list? Any directions please Hari Gillala
Hari Gillala
  • 11,736
  • 18
  • 70
  • 117
0
votes
2 answers

How can i merge duplicate rows in SQL with an special condition

i have a table with this structure ID Word description ------------------------------- 1 book a lot of paper 2 book a thing 3 book an amazing thing 4 tv television i want to convert this table…
Hossein
  • 77
  • 1
  • 1
  • 11
0
votes
3 answers

JAVA, SQL, insert into no-duplicates

I am trying to insert into a table without duplicates. I am using SQL derbyclient in Java. The code is not working (error with 'where not exists'). Any idea? Connection connection =…
Marcin Pisarek
  • 3
  • 1
  • 3
0
votes
1 answer

Find records without reciprocal record in a mysql table

I have a table let's say it has Color in one field and Shape in the other but in no particular field order: FIELD1 | FIELD2 ---------|---------- Red | Triangle Red | Square Red | Circle Triangle | Red Square | Red I am trying to…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
1 answer

Removing duplicates in MS Access 2010 (like in Excel)

I currently have some MS Access tables which are too large to be handled using Excel. I basically need to know how to remove duplicates based on one column, thus deleting lines and keeping everything else unchanged. Example: This is an example of…
user3037142
  • 1
1 2
3
4 5