Click here to Skip to main content
12,950,084 members (70,843 online)
   

Database

 
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 

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.


Advertise | Privacy | Mobile
Web01 | 2.8.170525.1 | Last Updated 25 May 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid