Click here to Skip to main content
15,441,568 members
Home / Discussions / Database
   

Database

 
SuggestionRe: SQL server 12: Displaying column cell values in single cell Pin
ZurdoDev17-Feb-15 2:54
professionalZurdoDev17-Feb-15 2:54 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Swap917-Feb-15 2:58
MemberSwap917-Feb-15 2:58 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
ZurdoDev17-Feb-15 3:00
professionalZurdoDev17-Feb-15 3:00 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Swap917-Feb-15 3:15
MemberSwap917-Feb-15 3:15 
AnswerRe: SQL server 12: Displaying column cell values in single cell Pin
ZurdoDev17-Feb-15 3:24
professionalZurdoDev17-Feb-15 3:24 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Swap917-Feb-15 3:40
MemberSwap917-Feb-15 3:40 
QuestionRe: SQL server 12: Displaying column cell values in single cell Pin
Eddy Vluggen17-Feb-15 4:38
professionalEddy Vluggen17-Feb-15 4:38 
AnswerRe: SQL server 12: Displaying column cell values in single cell Pin
Richard Deeming17-Feb-15 4:01
mveRichard Deeming17-Feb-15 4:01 
This sort of manipulation is best done in the UI, not the database.

However, using the techniques from this blog post[^] leads to the following (rather ugly) solution:
SQL
SELECT
    STUFF(
        (SELECT '/' + Surname + ',' + STUFF(
            (SELECT '-' + Forename 
            FROM YourTable As T2 
            WHERE T2.Surname = T1.Surname 
            ORDER BY T2.Forename 
            FOR XML PATH(''), TYPE
        ).value('.', 'varchar(max)')
        , 1, 1, '')
        FROM YourTable As T1
        GROUP BY Surname
        ORDER BY Surname
        FOR XML PATH(''), TYPE
    ).value('.', 'varchar(max)')
    , 1, 1, '') As CombinedNames
;




"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Swap917-Feb-15 5:16
MemberSwap917-Feb-15 5:16 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Richard Deeming17-Feb-15 5:22
mveRichard Deeming17-Feb-15 5:22 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Swap917-Feb-15 5:36
MemberSwap917-Feb-15 5:36 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Richard Deeming17-Feb-15 5:44
mveRichard Deeming17-Feb-15 5:44 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Swap917-Feb-15 5:51
MemberSwap917-Feb-15 5:51 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Richard Deeming17-Feb-15 5:59
mveRichard Deeming17-Feb-15 5:59 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Richard Deeming17-Feb-15 10:23
mveRichard Deeming17-Feb-15 10:23 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Swap917-Feb-15 21:49
MemberSwap917-Feb-15 21:49 
QuestionSQL Optimization Pin
Chaminda Bandara16-Feb-15 20:59
professionalChaminda Bandara16-Feb-15 20:59 
AnswerRe: SQL Optimization Pin
Richard MacCutchan16-Feb-15 21:33
mveRichard MacCutchan16-Feb-15 21:33 
AnswerRe: SQL Optimization Pin
Corporal Agarn17-Feb-15 1:45
professionalCorporal Agarn17-Feb-15 1:45 
AnswerRe: SQL Optimization Pin
Mycroft Holmes17-Feb-15 14:03
professionalMycroft Holmes17-Feb-15 14:03 
GeneralRe: SQL Optimization Pin
Chaminda Bandara17-Feb-15 19:06
professionalChaminda Bandara17-Feb-15 19:06 
GeneralRe: SQL Optimization Pin
Mycroft Holmes18-Feb-15 1:14
professionalMycroft Holmes18-Feb-15 1:14 
QuestionVersioned data strategy Pin
LostTheMarbles15-Feb-15 21:08
professionalLostTheMarbles15-Feb-15 21:08 
AnswerRe: Versioned data strategy Pin
GuyThiebaut16-Feb-15 1:44
professionalGuyThiebaut16-Feb-15 1:44 
AnswerRe: Versioned data strategy Pin
Mycroft Holmes17-Feb-15 13:59
professionalMycroft Holmes17-Feb-15 13:59 

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.