Click here to Skip to main content
15,357,682 members
Home / Discussions / Database
   

Database

 
GeneralRe: Storing data which in the form of a list to database. Pin
udaykatakam24-Aug-09 11:29
Memberudaykatakam24-Aug-09 11:29 
QuestionAbout the SQL Execution Plan Pin
mctramp16820-Aug-09 22:09
Membermctramp16820-Aug-09 22:09 
AnswerRe: About the SQL Execution Plan Pin
Ashfield20-Aug-09 23:19
MemberAshfield20-Aug-09 23:19 
AnswerRe: About the SQL Execution Plan Pin
Mycroft Holmes21-Aug-09 0:38
professionalMycroft Holmes21-Aug-09 0:38 
GeneralRe: About the SQL Execution Plan Pin
David Mujica21-Aug-09 2:54
MemberDavid Mujica21-Aug-09 2:54 
QuestionSQL:Find one primary key of each duplicate records Pin
xodeblack20-Aug-09 19:42
Memberxodeblack20-Aug-09 19:42 
AnswerRe: SQL:Find one primary key of each duplicate records Pin
Ashfield20-Aug-09 21:01
MemberAshfield20-Aug-09 21:01 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
xodeblack20-Aug-09 21:25
Memberxodeblack20-Aug-09 21:25 
Hi Ashfield
First of all thankz for your reply

It returns only one PK....I want to get
one PK of each duplicate record ....
According to last example I want one PK of 2222(Trans. ID),one PK of 7777(Trans. ID) and one PK of 9999(Trans. ID)
so one possible result is
11,14,17
Other possible result is
12,14,17
One more possible result is
13,14,17
.........
Now I think you understand what I want
waiting your reply
GeneralRe: SQL:Find one primary key of each duplicate records Pin
Ashfield21-Aug-09 1:21
MemberAshfield21-Aug-09 1:21 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
xodeblack21-Aug-09 1:28
Memberxodeblack21-Aug-09 1:28 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
Ashfield21-Aug-09 4:20
MemberAshfield21-Aug-09 4:20 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
Coding C#20-Aug-09 22:25
MemberCoding C#20-Aug-09 22:25 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
David Skelly20-Aug-09 22:32
MemberDavid Skelly20-Aug-09 22:32 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
Ashfield21-Aug-09 1:19
MemberAshfield21-Aug-09 1:19 
QuestionLIKE Predicate Pin
TheIdleProgrammer20-Aug-09 3:50
MemberTheIdleProgrammer20-Aug-09 3:50 
AnswerRe: LIKE Predicate Pin
Mycroft Holmes20-Aug-09 4:17
professionalMycroft Holmes20-Aug-09 4:17 
GeneralRe: LIKE Predicate Pin
TheIdleProgrammer20-Aug-09 4:28
MemberTheIdleProgrammer20-Aug-09 4:28 
GeneralRe: LIKE Predicate Pin
Mycroft Holmes20-Aug-09 13:15
professionalMycroft Holmes20-Aug-09 13:15 
GeneralRe: LIKE Predicate Pin
TheIdleProgrammer20-Aug-09 22:10
MemberTheIdleProgrammer20-Aug-09 22:10 
GeneralRe: LIKE Predicate Pin
Mycroft Holmes21-Aug-09 0:33
professionalMycroft Holmes21-Aug-09 0:33 
GeneralRe: LIKE Predicate Pin
David Skelly20-Aug-09 22:53
MemberDavid Skelly20-Aug-09 22:53 
GeneralRe: LIKE Predicate Pin
TheIdleProgrammer20-Aug-09 23:07
MemberTheIdleProgrammer20-Aug-09 23:07 
AnswerRe: LIKE Predicate Pin
Luc Pattyn20-Aug-09 4:58
sitebuilderLuc Pattyn20-Aug-09 4:58 
GeneralRe: LIKE Predicate Pin
TheIdleProgrammer20-Aug-09 22:11
MemberTheIdleProgrammer20-Aug-09 22:11 
QuestionSql Problem Pin
AhmedGebaly19-Aug-09 23:37
MemberAhmedGebaly19-Aug-09 23:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.