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

Database

 
GeneralRe: DateTime between two times Pin
Chris Meech11-May-05 9:20
Chris Meech11-May-05 9:20 
Generaldatabase Design Pin
imshally8110-May-05 23:59
imshally8110-May-05 23:59 
GeneralRe: database Design Pin
Anonymous11-May-05 0:22
Anonymous11-May-05 0:22 
GeneralRe: database Design Pin
hp10811-May-05 0:37
hp10811-May-05 0:37 
GeneralIF Statement with in Query Pin
si_6910-May-05 7:23
si_6910-May-05 7:23 
GeneralRe: IF Statement with in Query Pin
Filipe Peixinho10-May-05 7:58
Filipe Peixinho10-May-05 7:58 
GeneralRe: IF Statement with in Query Pin
Member 195262810-May-05 15:03
Member 195262810-May-05 15:03 
GeneralNeed help on this query Pin
Filipe Peixinho10-May-05 6:10
Filipe Peixinho10-May-05 6:10 
Hello all.
I'm almost getting my head to the wall Confused | :confused: because I can't get to the solution for a query I need to do.
Is anyone here wanting to help me ?

Let me explain the problem:

I have a table named T1 with the following structure:
ID | Subject | ParentID

This table represents info in a form of tree and when I'm at the top branch the ID and ParentID fields have the same value.
If I have the following data

ID Subject ParentID
1 Sub1 1
2 Sub2 2
3 Sub1_1 1
4 Sub1_2 1
5 Sub1_1_1 3

I want to make a query with the following result:

ID|Subject|NumberOfChildRecords

e.g.:
1 | Sub1 | 2
2 | Sub2 | 0
3 | Sub1_1 | 1
4 | Sub1_2 | 0
5 | Sub1_1_1 | 0

Is this simple to do ?
Thanks in advance for the attention you are having reading this.


GeneralRe: Need help on this query Pin
jasncab10-May-05 14:23
jasncab10-May-05 14:23 
GeneralOracleHelper Pin
Nizar Abdeljaoued10-May-05 5:30
Nizar Abdeljaoued10-May-05 5:30 
GeneralStock Update - Database Concurrency problem Pin
crowofatlantis10-May-05 1:54
crowofatlantis10-May-05 1:54 
GeneralTransact SQL Pin
Anonymous10-May-05 1:54
Anonymous10-May-05 1:54 
GeneralRe: Transact SQL Pin
Colin Angus Mackay10-May-05 3:37
Colin Angus Mackay10-May-05 3:37 
GeneralRe: Transact SQL Pin
Anonymous10-May-05 21:55
Anonymous10-May-05 21:55 
GeneralDatabase schema Pin
Member 1697710-May-05 0:15
Member 1697710-May-05 0:15 
GeneralRe: Database schema Pin
Colin Angus Mackay10-May-05 0:43
Colin Angus Mackay10-May-05 0:43 
GeneralRe: Database schema Pin
Member 1697710-May-05 2:08
Member 1697710-May-05 2:08 
GeneralADO.NET output parameter Pin
Timothy_19829-May-05 20:58
Timothy_19829-May-05 20:58 
GeneralRe: ADO.NET output parameter Pin
Colin Angus Mackay9-May-05 22:49
Colin Angus Mackay9-May-05 22:49 
GeneralRe: ADO.NET output parameter Pin
Timothy_198210-May-05 0:00
Timothy_198210-May-05 0:00 
GeneralRemote query being executed multiple times Pin
alex12059-May-05 20:32
alex12059-May-05 20:32 
GeneralProblem to search with a hyphen Pin
Nik_Pick9-May-05 10:16
Nik_Pick9-May-05 10:16 
Questionsql server 2000 documentor? Pin
WDI9-May-05 10:14
WDI9-May-05 10:14 
AnswerRe: sql server 2000 documentor? Pin
-Dr_X-10-May-05 10:10
-Dr_X-10-May-05 10:10 
GeneralNewbie help VS2003, SQLDataAdapter and Update Pin
Richard Schaefer9-May-05 9:19
Richard Schaefer9-May-05 9:19 

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.