Click here to Skip to main content
16,017,279 members
Home / Discussions / Database
   

Database

 
Questioninserting values from select query Pin
dj.rock30-Oct-06 19:46
dj.rock30-Oct-06 19:46 
AnswerRe: inserting values from select query Pin
neilsolent31-Oct-06 0:54
neilsolent31-Oct-06 0:54 
QuestionHow to store an 1:N tree (Hierarchy) Pin
peterchen30-Oct-06 14:52
peterchen30-Oct-06 14:52 
AnswerRe: How to store an 1:N tree (Hierarchy) Pin
Colin Angus Mackay31-Oct-06 4:37
Colin Angus Mackay31-Oct-06 4:37 
AnswerRe: How to store an 1:N tree (Hierarchy) Pin
Damodar Periwal31-Oct-06 9:46
Damodar Periwal31-Oct-06 9:46 
AnswerRe: How to store an 1:N tree (Hierarchy) Pin
Eric Dahlvang1-Nov-06 11:31
Eric Dahlvang1-Nov-06 11:31 
QuestionMicrosoft Access VBA Question About ListBoxes... Pin
new_phoenix30-Oct-06 14:15
new_phoenix30-Oct-06 14:15 
QuestionSQL Select Puzzle Pin
neilsolent30-Oct-06 9:51
neilsolent30-Oct-06 9:51 
All,

I have the following table:


CREATE TABLE X
(
ID tinyint NOT NULL,
PARENT_ID tinyint NOT NULL,
CONSTRAINT X1 PRIMARY KEY (ID)
)
go

How can I write a select on it which order rows such that, a row with a particular ID appears BEFORE
a row which has the same value for PARENT_ID?




cheers,
Neil

AnswerRe: SQL Select Puzzle Pin
Eric Dahlvang31-Oct-06 3:07
Eric Dahlvang31-Oct-06 3:07 
QuestionWhere can I lean about stored procedures? Pin
CCMint30-Oct-06 7:01
CCMint30-Oct-06 7:01 
QuestionCOPY TABLE giving unexpected EOF error Pin
Zeolite30-Oct-06 6:55
Zeolite30-Oct-06 6:55 
QuestionBest way to save data Pin
knappster30-Oct-06 1:43
knappster30-Oct-06 1:43 
QuestionADO.NET related question Pin
Imtiaz Murtaza30-Oct-06 0:57
Imtiaz Murtaza30-Oct-06 0:57 
AnswerRe: ADO.NET related question Pin
Colin Angus Mackay30-Oct-06 1:54
Colin Angus Mackay30-Oct-06 1:54 
GeneralRe: ADO.NET related question Pin
Damodar Periwal31-Oct-06 10:14
Damodar Periwal31-Oct-06 10:14 
AnswerRe: ADO.NET related question Pin
Hunuman30-Oct-06 2:02
Hunuman30-Oct-06 2:02 
GeneralData Type Issue in Where Clause Pin
Brady Kelly30-Oct-06 0:13
Brady Kelly30-Oct-06 0:13 
JokeRe: Data Type Issue in Where Clause Pin
Rob Graham30-Oct-06 3:14
Rob Graham30-Oct-06 3:14 
Questionselect query filling 2 typed datasets Pin
steve_rm29-Oct-06 22:10
steve_rm29-Oct-06 22:10 
QuestionPurpose of SQL Server Jobs Pin
King Shez29-Oct-06 19:50
King Shez29-Oct-06 19:50 
AnswerRe: Purpose of SQL Server Jobs Pin
Eric Dahlvang30-Oct-06 3:13
Eric Dahlvang30-Oct-06 3:13 
Questionconnection cannot be made? Pin
Haoman1729-Oct-06 0:48
Haoman1729-Oct-06 0:48 
Questionconnecting to SQL express through ADO Pin
psasidisrcum28-Oct-06 11:54
psasidisrcum28-Oct-06 11:54 
AnswerRe: connecting to SQL express through ADO Pin
Jerry Hammond28-Oct-06 16:16
Jerry Hammond28-Oct-06 16:16 
GeneralRe: connecting to SQL express through ADO Pin
Colin Angus Mackay29-Oct-06 3:52
Colin Angus Mackay29-Oct-06 3:52 

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.