Click here to Skip to main content
15,919,423 members
Home / Discussions / Database
   

Database

 
QuestionBest practices for user defined fields Pin
econner20-Sep-05 16:42
econner20-Sep-05 16:42 
AnswerRe: Best practices for user defined fields Pin
Edbert P20-Sep-05 18:27
Edbert P20-Sep-05 18:27 
AnswerRe: Best practices for user defined fields Pin
Andy Brummer20-Sep-05 20:01
sitebuilderAndy Brummer20-Sep-05 20:01 
QuestionDatabound ComboBox Selection Problems Pin
Glenn E. Lanier II20-Sep-05 15:33
Glenn E. Lanier II20-Sep-05 15:33 
AnswerRe: Databound ComboBox Selection Problems Pin
sreejith ss nair22-Sep-05 1:06
sreejith ss nair22-Sep-05 1:06 
AnswerRe: Databound ComboBox Selection Problems Pin
Glenn E. Lanier II2-Mar-06 8:36
Glenn E. Lanier II2-Mar-06 8:36 
AnswerRe: Databound ComboBox Selection Problems Pin
miah alom22-Sep-05 3:23
miah alom22-Sep-05 3:23 
QuestionSelecting distinct values Pin
Filipe Peixinho20-Sep-05 12:28
Filipe Peixinho20-Sep-05 12:28 
Hello everybody.
Here's something is driving me crazy because I have the feeling it's a simple solution and I'm not getting there yet.
Can some one help me ?

Hee's the problem.

I have a table on SQL Server 2000 with the following records:

<br />
 ID                                     Date                    Flag    Description<br />
 B1E139CF-C5B8-4C6A-8951-197C0F2BB2AC	2005-09-20 18:00:00	0	Grupo 3<br />
 C472A346-A855-4721-8364-71AAA2B0D4A2	2005-09-20 18:00:00	0	Grupo 3<br />
 1ADAA758-C975-4C4D-AFFA-069CECDF7BF7	2005-09-21 00:00:00	0	Grupo 1<br />


I need to write a SELECT statement that return me one record for each description for any ID. Here's an example of the final output I need:

<br />
 ID                                     Date                    Flag    Description<br />
 B1E139CF-C5B8-4C6A-8951-197C0F2BB2AC	2005-09-20 18:00:00	0	Grupo 3<br />
 1ADAA758-C975-4C4D-AFFA-069CECDF7BF7	2005-09-21 00:00:00	0	Grupo 1<br />


Is this simple ? Is here anyone that can help me ?

Thanks in advance for all replies



-- modified at 18:29 Tuesday 20th September, 2005
AnswerRe: Selecting distinct values Pin
enjoycrack20-Sep-05 17:17
enjoycrack20-Sep-05 17:17 
GeneralRe: Selecting distinct values Pin
Filipe Peixinho21-Sep-05 0:55
Filipe Peixinho21-Sep-05 0:55 
GeneralRe: Selecting distinct values Pin
enjoycrack21-Sep-05 0:57
enjoycrack21-Sep-05 0:57 
GeneralRe: Selecting distinct values Pin
Filipe Peixinho21-Sep-05 1:12
Filipe Peixinho21-Sep-05 1:12 
GeneralRe: Selecting distinct values Pin
enjoycrack21-Sep-05 1:17
enjoycrack21-Sep-05 1:17 
GeneralRe: Selecting distinct values Pin
Filipe Peixinho21-Sep-05 1:38
Filipe Peixinho21-Sep-05 1:38 
GeneralRe: Selecting distinct values Pin
enjoycrack21-Sep-05 2:01
enjoycrack21-Sep-05 2:01 
GeneralRe: Selecting distinct values Pin
Filipe Peixinho21-Sep-05 3:26
Filipe Peixinho21-Sep-05 3:26 
GeneralRe: Selecting distinct values Pin
miah alom22-Sep-05 5:06
miah alom22-Sep-05 5:06 
QuestionWhen LIKE operator doesn't use indexes. Pin
Tupax20-Sep-05 6:18
Tupax20-Sep-05 6:18 
AnswerRe: When LIKE operator doesn't use indexes. Pin
Andy Brummer20-Sep-05 8:02
sitebuilderAndy Brummer20-Sep-05 8:02 
GeneralRe: When LIKE operator doesn't use indexes. Pin
Tupax20-Sep-05 21:43
Tupax20-Sep-05 21:43 
QuestionRe: When LIKE operator doesn't use indexes. Pin
Tupax20-Sep-05 21:57
Tupax20-Sep-05 21:57 
Questionusing xml Pin
suchita2420-Sep-05 0:50
suchita2420-Sep-05 0:50 
AnswerRe: using xml Pin
Frank Kerrigan20-Sep-05 0:55
Frank Kerrigan20-Sep-05 0:55 
GeneralRe: using xml Pin
sreejith ss nair20-Sep-05 1:09
sreejith ss nair20-Sep-05 1:09 
QuestionBig problem Pin
vtalau19-Sep-05 23:57
vtalau19-Sep-05 23:57 

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.