Click here to Skip to main content
11,721,053 members (83,354 online)
   

Database

 
AnswerRe: compare performance between two query Pin
Tim Carmichael5-Apr-13 3:11
memberTim Carmichael5-Apr-13 3:11 
AnswerRe: compare performance between two query Pin
PIEBALDconsult5-Apr-13 3:21
memberPIEBALDconsult5-Apr-13 3:21 
SuggestionRe: compare performance between two query Pin
Eddy Vluggen5-Apr-13 7:21
mvpEddy Vluggen5-Apr-13 7:21 
GeneralRe: compare performance between two query Pin
mehdi.sabet5-Apr-13 8:44
groupmehdi.sabet5-Apr-13 8:44 
GeneralRe: compare performance between two query Pin
Eddy Vluggen5-Apr-13 8:54
mvpEddy Vluggen5-Apr-13 8:54 
GeneralRe: compare performance between two query Pin
mehdi.sabet5-Apr-13 9:01
groupmehdi.sabet5-Apr-13 9:01 
GeneralRe: compare performance between two query Pin
Eddy Vluggen5-Apr-13 9:04
mvpEddy Vluggen5-Apr-13 9:04 
QuestionJOIN 3 Tables Pin
Richard.Berry1004-Apr-13 19:01
memberRichard.Berry1004-Apr-13 19:01 
AnswerRe: JOIN 3 Tables Pin
Mycroft Holmes4-Apr-13 20:04
professionalMycroft Holmes4-Apr-13 20:04 
GeneralRe: JOIN 3 Tables Pin
Richard.Berry1005-Apr-13 2:49
memberRichard.Berry1005-Apr-13 2:49 
GeneralRe: JOIN 3 Tables Pin
Mycroft Holmes5-Apr-13 13:12
professionalMycroft Holmes5-Apr-13 13:12 
GeneralRe: JOIN 3 Tables Pin
Richard.Berry1005-Apr-13 23:41
memberRichard.Berry1005-Apr-13 23:41 
GeneralRe: JOIN 3 Tables Pin
Mycroft Holmes6-Apr-13 14:14
professionalMycroft Holmes6-Apr-13 14:14 
QuestionSQL QUERY Pin
girijeshkumar3-Apr-13 20:08
membergirijeshkumar3-Apr-13 20:08 
plz help me am begginner to ms sql server

my question mulitple rowwise data should be display to one columnwise

suppose from table1 i created column like empname,reference

table2 i created column like reference and salary details

join both table retrieve and display empname, reference,and all salary details for particular employee in one column


table1 value
-----------------------------|
empname      |   referenceno
-----------------------------|
girijesh      |   111
-----------------------------|
ajay            |   121
-----------------------------|


table2 value
-----------------------------------------------------|
referenceno | salary
-----------------------------------------------------|
111            | jan-10000
-----------------------------------------------------|
111            | feb-20000
-----------------------------------------------------|
111            | mar-30000
-----------------------------------------------------|
121            | jan-10000
-----------------------------------------------------|
121            | feb-20000
-----------------------------------------------------|

so now result like below
-----------------------------------------------------|
empname   | reference |   salary
-----------------------------------------------------|
girijesh |   111         | jan-10000,feb-20000,mar-30000
-----------------------------------------------------|
ajay      |   121         | jan-10000,feb-20000
-----------------------------------------------------|
i want query to display like above result
AnswerRe: SQL QUERY Pin
i.j.russell3-Apr-13 21:36
memberi.j.russell3-Apr-13 21:36 
GeneralRe: SQL QUERY Pin
girijeshkumar3-Apr-13 23:05
membergirijeshkumar3-Apr-13 23:05 
GeneralRe: SQL QUERY Pin
i.j.russell4-Apr-13 2:07
memberi.j.russell4-Apr-13 2:07 
AnswerRe: SQL QUERY Pin
Bernhard Hiller3-Apr-13 21:38
memberBernhard Hiller3-Apr-13 21:38 
GeneralRe: SQL QUERY Pin
girijeshkumar3-Apr-13 23:07
membergirijeshkumar3-Apr-13 23:07 
AnswerRe: SQL QUERY Pin
ritesh.gupta55553-Apr-13 22:28
memberritesh.gupta55553-Apr-13 22:28 
GeneralRe: SQL QUERY Pin
girijeshkumar3-Apr-13 22:58
membergirijeshkumar3-Apr-13 22:58 
GeneralRe: SQL QUERY Pin
ritesh.gupta555525-Jun-13 2:55
memberritesh.gupta555525-Jun-13 2:55 
QuestionSQL QUERY Pin
Dobrobit2-Apr-13 8:41
memberDobrobit2-Apr-13 8:41 
AnswerRe: SQL QUERY Pin
David Mujica2-Apr-13 9:12
memberDavid Mujica2-Apr-13 9:12 
AnswerRe: SQL QUERY Pin
djj552-Apr-13 9:17
memberdjj552-Apr-13 9:17 
AnswerRe: SQL QUERY Pin
Richard Deeming2-Apr-13 10:40
professionalRichard Deeming2-Apr-13 10:40 
Questionwhen use of index on view instead of table Pin
mehdi.sabet2-Apr-13 7:01
groupmehdi.sabet2-Apr-13 7:01 
AnswerRe: when use of index on view instead of table Pin
mark merrens2-Apr-13 7:11
membermark merrens2-Apr-13 7:11 
Questionbenefit of cluster index on view in sql 2008 r2 Pin
mehdi.sabet2-Apr-13 1:45
groupmehdi.sabet2-Apr-13 1:45 
AnswerRe: benefit of cluster index on view in sql 2008 r2 Pin
Simon_Whale2-Apr-13 1:56
memberSimon_Whale2-Apr-13 1:56 
GeneralRe: benefit of cluster index on view in sql 2008 r2 Pin
mehdi.sabet2-Apr-13 5:16
groupmehdi.sabet2-Apr-13 5:16 
QuestionDifference in Sum(column) between two tables Pin
Richard.Berry1001-Apr-13 3:45
memberRichard.Berry1001-Apr-13 3:45 
AnswerRe: Difference in Sum(column) between two tables Pin
David Mujica1-Apr-13 4:12
memberDavid Mujica1-Apr-13 4:12 
GeneralRe: Difference in Sum(column) between two tables Pin
Richard.Berry1004-Apr-13 8:05
memberRichard.Berry1004-Apr-13 8:05 
AnswerRe: Difference in Sum(column) between two tables Pin
Jörgen Andersson1-Apr-13 8:21
memberJörgen Andersson1-Apr-13 8:21 
GeneralRe: Difference in Sum(column) between two tables Pin
Richard.Berry1004-Apr-13 7:34
memberRichard.Berry1004-Apr-13 7:34 
Question2pc in SQL server Pin
Soiraian31-Mar-13 6:21
memberSoiraian31-Mar-13 6:21 
AnswerRe: 2pc in SQL server Pin
RedDK31-Mar-13 7:44
memberRedDK31-Mar-13 7:44 
QuestionViews vs Tables Pin
Eric Whitmore29-Mar-13 4:50
memberEric Whitmore29-Mar-13 4:50 
AnswerRe: Views vs Tables Pin
PIEBALDconsult29-Mar-13 5:37
memberPIEBALDconsult29-Mar-13 5:37 
GeneralRe: Views vs Tables Pin
Eric Whitmore29-Mar-13 5:47
memberEric Whitmore29-Mar-13 5:47 
GeneralRe: Views vs Tables Pin
PIEBALDconsult29-Mar-13 6:21
memberPIEBALDconsult29-Mar-13 6:21 
GeneralRe: Views vs Tables Pin
GuyThiebaut30-Mar-13 5:29
memberGuyThiebaut30-Mar-13 5:29 
GeneralRe: Views vs Tables Pin
PIEBALDconsult30-Mar-13 5:51
memberPIEBALDconsult30-Mar-13 5:51 
GeneralRe: Views vs Tables Pin
GuyThiebaut30-Mar-13 5:57
memberGuyThiebaut30-Mar-13 5:57 
GeneralRe: Views vs Tables Pin
jschell30-Mar-13 12:46
memberjschell30-Mar-13 12:46 
GeneralRe: Views vs Tables Pin
GuyThiebaut30-Mar-13 20:37
memberGuyThiebaut30-Mar-13 20:37 
GeneralRe: Views vs Tables Pin
jschell31-Mar-13 11:31
memberjschell31-Mar-13 11:31 
GeneralRe: Views vs Tables Pin
jschell30-Mar-13 12:45
memberjschell30-Mar-13 12:45 
AnswerRe: Views vs Tables Pin
djj5529-Mar-13 7:43
memberdjj5529-Mar-13 7:43 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.150901.1 | Last Updated 5 Sep 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid