Click here to Skip to main content
16,003,555 members
Home / Discussions / Database
   

Database

 
GeneralRe: mysql, query performance question Pin
mark_me28-Jul-09 5:06
mark_me28-Jul-09 5:06 
AnswerRe: mysql, query performance question Pin
Mycroft Holmes27-Jul-09 17:40
professionalMycroft Holmes27-Jul-09 17:40 
GeneralRe: mysql, query performance question Pin
mark_me28-Jul-09 5:07
mark_me28-Jul-09 5:07 
AnswerRe: mysql, query performance question Pin
Robin_Roy27-Jul-09 18:06
Robin_Roy27-Jul-09 18:06 
QuestionSQL Stored Procedure push in the right direction :) Pin
cdietschrun27-Jul-09 10:46
cdietschrun27-Jul-09 10:46 
AnswerRe: SQL Stored Procedure push in the right direction :) Pin
Mike Ellison27-Jul-09 14:35
Mike Ellison27-Jul-09 14:35 
QuestionSSIS Package - Urgent need Help Pin
vasini27-Jul-09 7:39
vasini27-Jul-09 7:39 
AnswerRe: SSIS Package - Urgent need Help Pin
Abhijit Jana27-Jul-09 8:31
professionalAbhijit Jana27-Jul-09 8:31 
AnswerPlease Read Forum Guidelines Pin
leckey27-Jul-09 10:42
leckey27-Jul-09 10:42 
AnswerRe: SSIS Package - Urgent need Help Pin
Robin_Roy27-Jul-09 17:04
Robin_Roy27-Jul-09 17:04 
QuestionLoosing decimal values while selecting in Oracle Pin
sandhya1426-Jul-09 20:11
sandhya1426-Jul-09 20:11 
AnswerRe: Loosing decimal values while selecting in Oracle Pin
Mycroft Holmes26-Jul-09 20:54
professionalMycroft Holmes26-Jul-09 20:54 
GeneralRe: Loosing decimal values while selecting in Oracle Pin
sandhya1426-Jul-09 21:06
sandhya1426-Jul-09 21:06 
Questionhow to do this result output Pin
VinothRao26-Jul-09 17:53
VinothRao26-Jul-09 17:53 
AnswerRe: how to do this result output Pin
Robin_Roy26-Jul-09 18:14
Robin_Roy26-Jul-09 18:14 
GeneralRe: how to do this result output Pin
VinothRao26-Jul-09 18:27
VinothRao26-Jul-09 18:27 
GeneralRe: how to do this result output Pin
dan!sh 26-Jul-09 18:56
professional dan!sh 26-Jul-09 18:56 
AnswerRe: how to do this result output Pin
Mycroft Holmes26-Jul-09 18:57
professionalMycroft Holmes26-Jul-09 18:57 
AnswerRe: how to do this result output Pin
J4amieC27-Jul-09 0:30
J4amieC27-Jul-09 0:30 
Questionsql statement help Pin
VinothRao26-Jul-09 15:56
VinothRao26-Jul-09 15:56 
hi,

i have the following table.

Parent ID.......ID.......Name
NULL..........10001.....Region1
NULL..........10002.....Region2
NULL..........10003.....Region3
10001.........501.......Test1
10001.........502.......Test2
10002.........503.......Test3
10002.........504.......Test4
10003.........505.......Test5
10003.........506.......Test6
501...........507.......Test7
501...........508.......Test8
502...........509.......Test9
502...........510.......Test10

Actually im doing a Treeview control in my ASP.NET application.
I can see the Parent Name, and its child popping out, BUT how to see the ID (501, 502) is having child in ParentID??

My SQL in ASP.NET is "SELECT ID, ParentID, Name FROM Test"
In order to show Child in the Parent, the ParentID has to be NULL.

Any idea??
AnswerRe: sql statement help Pin
Robin_Roy26-Jul-09 18:20
Robin_Roy26-Jul-09 18:20 
QuestionPassword in SqlServer 2005 Pin
SajjadZare25-Jul-09 18:58
SajjadZare25-Jul-09 18:58 
AnswerRe: Password in SqlServer 2005 Pin
Abhijit Jana25-Jul-09 22:32
professionalAbhijit Jana25-Jul-09 22:32 
AnswerRe: Password in SqlServer 2005 Pin
Mycroft Holmes26-Jul-09 14:11
professionalMycroft Holmes26-Jul-09 14:11 
GeneralRe: Password in SqlServer 2005 Pin
Andy_L_J26-Jul-09 20:00
Andy_L_J26-Jul-09 20:00 

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.