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

Database

 
QuestionLoad data from Excel which has columns in multiple rows Pin
indian14328-Oct-15 4:08
indian14328-Oct-15 4:08 
AnswerRe: Load data from Excel which has columns in multiple rows Pin
Richard MacCutchan28-Oct-15 7:18
mveRichard MacCutchan28-Oct-15 7:18 
GeneralRe: Load data from Excel which has columns in multiple rows Pin
indian14328-Oct-15 8:37
indian14328-Oct-15 8:37 
GeneralRe: Load data from Excel which has columns in multiple rows Pin
Richard Deeming28-Oct-15 10:05
mveRichard Deeming28-Oct-15 10:05 
GeneralRe: Load data from Excel which has columns in multiple rows Pin
indian14328-Oct-15 11:02
indian14328-Oct-15 11:02 
QuestionUse column output, to get new column Pin
Karan_TN27-Oct-15 19:54
Karan_TN27-Oct-15 19:54 
AnswerRe: Use column output, to get new column Pin
Mycroft Holmes27-Oct-15 20:42
professionalMycroft Holmes27-Oct-15 20:42 
Questionselect to Cancatenate sub group values under a group Pin
indian14327-Oct-15 3:07
indian14327-Oct-15 3:07 
Hi All,

I have a table A in it I have columns like Id, ParentId, ParentName, Child1Id, Child1Name, Child2Id, Child2Name. ParentId is the parent of Child1Id, and Child1Id is the parent of Chil2Id. Id is the Primary key of this table.

I want to have a select statement which, I have to get ParentIds, ParentNames order by ParentNames, under each Parent, I want to have Child1Ids, Child1Names, order by Child1 Names, Under each Child1s, I want to have its child2Ids and Child2Names.
ParentId, ParentName
Child1Id, Child1Name
Child2Id Child2Name
Child2Id Child2Name
Child2Id Child2Name
Child1Id Chil1Name
Child2Id Child2Name
Is there any way to write a query like this? Please help me, any type of help, a link, a code snippet or a suggestion would be greatly helpful, thanks in advance.
Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."

QuestionStoring Result Of A Select Statement In A Variable Pin
MadDashCoder23-Oct-15 13:13
MadDashCoder23-Oct-15 13:13 
AnswerRe: Storing Result Of A Select Statement In A Variable Pin
CHill6025-Oct-15 4:52
mveCHill6025-Oct-15 4:52 
AnswerRe: Storing Result Of A Select Statement In A Variable Pin
Anudeep Jaiswal - MCA17-Nov-15 18:22
Anudeep Jaiswal - MCA17-Nov-15 18:22 
Questionhow to create a database if data is given? Pin
Member 1127090223-Oct-15 6:00
Member 1127090223-Oct-15 6:00 
AnswerRe: how to create a database if data is given? Pin
Eddy Vluggen23-Oct-15 6:29
professionalEddy Vluggen23-Oct-15 6:29 
GeneralRe: how to create a database if data is given? Pin
Member 1127090223-Oct-15 7:02
Member 1127090223-Oct-15 7:02 
GeneralRe: how to create a database if data is given? Pin
Eddy Vluggen23-Oct-15 7:17
professionalEddy Vluggen23-Oct-15 7:17 
GeneralRe: how to create a database if data is given? Pin
Member 1127090223-Oct-15 7:28
Member 1127090223-Oct-15 7:28 
GeneralRe: how to create a database if data is given? Pin
Eddy Vluggen23-Oct-15 8:08
professionalEddy Vluggen23-Oct-15 8:08 
GeneralRe: how to create a database if data is given? Pin
Member 1127090223-Oct-15 8:25
Member 1127090223-Oct-15 8:25 
GeneralRe: how to create a database if data is given? Pin
Eddy Vluggen23-Oct-15 8:31
professionalEddy Vluggen23-Oct-15 8:31 
GeneralRe: how to create a database if data is given? Pin
Member 1127090223-Oct-15 8:49
Member 1127090223-Oct-15 8:49 
GeneralRe: how to create a database if data is given? Pin
Eddy Vluggen23-Oct-15 8:55
professionalEddy Vluggen23-Oct-15 8:55 
GeneralRe: how to create a database if data is given? Pin
Member 1127090223-Oct-15 9:02
Member 1127090223-Oct-15 9:02 
GeneralRe: how to create a database if data is given? Pin
Eddy Vluggen23-Oct-15 9:14
professionalEddy Vluggen23-Oct-15 9:14 
GeneralRe: how to create a database if data is given? Pin
Member 1127090223-Oct-15 9:20
Member 1127090223-Oct-15 9:20 
GeneralRe: how to create a database if data is given? Pin
Eddy Vluggen23-Oct-15 9:48
professionalEddy Vluggen23-Oct-15 9:48 

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.