Click here to Skip to main content
16,020,315 members
Home / Discussions / Database
   

Database

 
GeneralRe: Getting unique combination of rows in SQL?? Pin
Lima319-Apr-12 2:38
Lima319-Apr-12 2:38 
GeneralRe: Getting unique combination of rows in SQL?? Pin
Blue_Boy19-Apr-12 2:45
Blue_Boy19-Apr-12 2:45 
QuestionTraking Offence Pin
Billa218-Apr-12 20:06
Billa218-Apr-12 20:06 
AnswerRe: Traking Offence Pin
Mohibur Rashid18-Apr-12 20:45
professionalMohibur Rashid18-Apr-12 20:45 
GeneralRe: Traking Offence Pin
Billa218-Apr-12 22:09
Billa218-Apr-12 22:09 
Questioncomplicated SQL: How to filter duplicate data about technical support and compute rank Pin
bbaaking16-Apr-12 16:54
bbaaking16-Apr-12 16:54 
AnswerRe: How to filter duplicate data about technical support and compute rank Pin
TenmanS1417-Apr-12 11:00
TenmanS1417-Apr-12 11:00 
GeneralRe: How to filter duplicate data about technical support and compute rank Pin
bbaaking17-Apr-12 16:41
bbaaking17-Apr-12 16:41 
thank you for your reply, but I need a resultset object, It's hard to write it step by step like your solution.
I mean I need a single query statement
my result of goal 1 should be:
SQL
2000	2	Jacob	2011/1/1	2
2001	4	Jacob	2011/1/1	2
2002	5	Jacob	2011/2/3	1
2003	6	Tyler	2011/1/4	1
2004	9	Jacob	2011/2/4	1
2005	10	Jacob	2011/2/5	1
2006	11	Jacob	2011/2/4	2
2007	12	Jacob	2011/1/8	1
2008	13	Tyler	2011/2/6	1
2009	14	Dyla	2011/2/8	1
2010	15	Dyla	2011/2/9	1
2011	19	Andrew	2011/2/2	1
2012	18	Andrew	2011/2/19	1
2013	17	Andrew	2011/1/1	1
2014	16	Andrew	2011/1/1	1
2015	20	Andrew	2011/2/1	1
2016	21	Andrew	2011/1/19	1
2017	22	Jacob	2011/1/1	1
2018	23	Dyla	2011/2/3	1
2019	24	Dyla	2011/1/9	1
2020	25	Dyla	2011/1/1	1
2021	26	Andrew	2011/1/3	1
2022	28	Jacob	2011/1/9	1
2023	29	Tyler	2011/1/19	1
2024	30	Andrew	2011/2/1	1
2025	31	Dyla	2011/2/3	1
2026	32	Jacob	2011/2/4	1
2027	33	Tyler	2011/2/9	1
2028	34	Daniel	2011/1/6	1
2029	35	Daniel	2011/2/1	1

GeneralRe: How to filter duplicate data about technical support and compute rank Pin
TenmanS1417-Apr-12 21:59
TenmanS1417-Apr-12 21:59 
GeneralRe: How to filter duplicate data about technical support and compute rank Pin
bbaaking17-Apr-12 22:20
bbaaking17-Apr-12 22:20 
AnswerRe: How to filter duplicate data about technical support and compute rank Pin
Jörgen Andersson17-Apr-12 22:37
professionalJörgen Andersson17-Apr-12 22:37 
GeneralRe: How to filter duplicate data about technical support and compute rank Pin
bbaaking17-Apr-12 22:54
bbaaking17-Apr-12 22:54 
AnswerRe: complicated SQL: How to filter duplicate data about technical support and compute rank Pin
TenmanS1418-Apr-12 11:40
TenmanS1418-Apr-12 11:40 
GeneralRe: complicated SQL: How to filter duplicate data about technical support and compute rank Pin
bbaaking18-Apr-12 21:56
bbaaking18-Apr-12 21:56 
AnswerI have solved it by myself Pin
bbaaking22-Apr-12 20:22
bbaaking22-Apr-12 20:22 
SuggestionSync data Bi-Directional Automatically- Sql Server 2008 Pin
dsrao16-Apr-12 11:49
dsrao16-Apr-12 11:49 
GeneralRe: Sync data Bi-Directional Automatically- Sql Server 2008 Pin
kalaisw17-Apr-12 2:06
kalaisw17-Apr-12 2:06 
GeneralRe: Sync data Bi-Directional Automatically- Sql Server 2008 Pin
dsrao17-Apr-12 6:48
dsrao17-Apr-12 6:48 
GeneralRe: Sync data Bi-Directional Automatically- Sql Server 2008 Pin
TenmanS1419-Apr-12 4:44
TenmanS1419-Apr-12 4:44 
GeneralRe: Sync data Bi-Directional Automatically- Sql Server 2008 Pin
JosephvObrien19-Apr-12 22:14
JosephvObrien19-Apr-12 22:14 
QuestionT-SQL Developer needed for hire. Pin
SQL Ed15-Apr-12 5:13
SQL Ed15-Apr-12 5:13 
AnswerRe: T-SQL Developer needed for hire. Pin
Mycroft Holmes15-Apr-12 13:54
professionalMycroft Holmes15-Apr-12 13:54 
GeneralRe: T-SQL Developer needed for hire. Pin
SQL Ed16-Apr-12 0:32
SQL Ed16-Apr-12 0:32 
GeneralRe: T-SQL Developer needed for hire. Pin
SQL Ed16-Apr-12 0:32
SQL Ed16-Apr-12 0:32 
GeneralRe: T-SQL Developer needed for hire. Pin
Mycroft Holmes16-Apr-12 3:15
professionalMycroft Holmes16-Apr-12 3:15 

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.