Click here to Skip to main content
15,557,928 members
Home / Discussions / Database
   

Database

 
PinnedHOW TO ANSWER A QUESTION PinPopular
Chris Maunder16-Jul-09 4:10
cofounderChris Maunder16-Jul-09 4:10 
PinnedHow to get an answer to your question PinPopular
Chris Maunder10-Nov-05 17:30
cofounderChris Maunder10-Nov-05 17:30 
QuestionQuestion On SQL Query Result Pin
crmfghtr20-Jan-23 6:13
crmfghtr20-Jan-23 6:13 
AnswerRe: Question On SQL Query Result Pin
Richard Deeming20-Jan-23 6:33
mveRichard Deeming20-Jan-23 6:33 
PraiseRe: Question On SQL Query Result Pin
crmfghtr20-Jan-23 6:41
crmfghtr20-Jan-23 6:41 
AnswerRe: Question On SQL Query Result Pin
Mycroft Holmes20-Jan-23 12:34
professionalMycroft Holmes20-Jan-23 12:34 
GeneralRe: Question On SQL Query Result Pin
crmfghtr20-Jan-23 13:41
crmfghtr20-Jan-23 13:41 
QuestionEF Core 6 Exclude Columns Pin
Kevin Marois19-Dec-22 9:47
professionalKevin Marois19-Dec-22 9:47 
AnswerRe: EF Core 6 Exclude Columns Pin
Dave Kreskowiak19-Dec-22 16:47
mveDave Kreskowiak19-Dec-22 16:47 
GeneralRe: EF Core 6 Exclude Columns Pin
Kevin Marois23-Dec-22 8:36
professionalKevin Marois23-Dec-22 8:36 
QuestionUsing SQL Native Backup URL, multiple databases to Azure Blob Storage Pin
Jaime Maccou9-Dec-22 2:00
Jaime Maccou9-Dec-22 2:00 
AnswerRe: Using SQL Native Backup URL, multiple databases to Azure Blob Storage Pin
jschell12-Dec-22 11:33
jschell12-Dec-22 11:33 
QuestionEntity Framework Core 6 VARCHAR(MAX) Pin
Kevin Marois8-Dec-22 13:54
professionalKevin Marois8-Dec-22 13:54 
AnswerRe: Entity Framework Core 6 VARCHAR(MAX) Pin
Victor Nijegorodov8-Dec-22 19:24
Victor Nijegorodov8-Dec-22 19:24 
GeneralRe: Entity Framework Core 6 VARCHAR(MAX) Pin
Kevin Marois9-Dec-22 12:47
professionalKevin Marois9-Dec-22 12:47 
GeneralRe: Entity Framework Core 6 VARCHAR(MAX) Pin
jschell12-Dec-22 11:35
jschell12-Dec-22 11:35 
QuestionSOLVED - Pivot a result set Pin
Richard Andrew x6428-Nov-22 6:46
professionalRichard Andrew x6428-Nov-22 6:46 
I need to create a subquery that pulls detail records for the header records in the main query.

But I'd like to display values from the detail records in the form of a comma separated list, like so, "value1, value2, value3". And this list should appear as an extra column in the result set.

Is there any way to achieve this in SQL Server?

SOLUTION: Use the STRING_AGG function! Cool.



The difficult we do right away...
...the impossible takes slightly longer.

AnswerRe: SOLVED - Pivot a result set Pin
Richard Deeming28-Nov-22 22:24
mveRichard Deeming28-Nov-22 22:24 
QuestionTSQL - JOIN cancels out my date filter Pin
jkirkerx27-Nov-22 14:53
professionaljkirkerx27-Nov-22 14:53 
AnswerRe: TSQL - JOIN cancels out my date filter Pin
Graham Breach27-Nov-22 22:38
Graham Breach27-Nov-22 22:38 
GeneralRe: TSQL - JOIN cancels out my date filter Pin
jkirkerx28-Nov-22 7:32
professionaljkirkerx28-Nov-22 7:32 
GeneralRe: TSQL - JOIN cancels out my date filter Pin
jschell28-Nov-22 11:44
jschell28-Nov-22 11:44 
QuestionTSQL - Create a JOIN, knowing that it may not exist, but show the initial records at least instead of nothing [bad idea] - abandoned it Pin
jkirkerx21-Nov-22 10:15
professionaljkirkerx21-Nov-22 10:15 
AnswerMaybe this is a bad idea, so I abandoned it. Did a work around instead. Pin
jkirkerx21-Nov-22 10:35
professionaljkirkerx21-Nov-22 10:35 
AnswerRe: TSQL - Create a JOIN, knowing that it may not exist, but show the initial records at least instead of nothing [bad idea] - abandoned it Pin
Graham Breach21-Nov-22 11:29
Graham Breach21-Nov-22 11:29 

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.