Click here to Skip to main content
15,917,005 members
Home / Discussions / Database
   

Database

 
GeneralRe: EF Core 6 Exclude Columns Pin
Kevin Marois23-Dec-22 7:36
professionalKevin Marois23-Dec-22 7:36 
QuestionUsing SQL Native Backup URL, multiple databases to Azure Blob Storage Pin
Jaime Maccou9-Dec-22 1:00
Jaime Maccou9-Dec-22 1:00 
AnswerRe: Using SQL Native Backup URL, multiple databases to Azure Blob Storage Pin
jschell12-Dec-22 10:33
jschell12-Dec-22 10:33 
QuestionEntity Framework Core 6 VARCHAR(MAX) Pin
Kevin Marois8-Dec-22 12:54
professionalKevin Marois8-Dec-22 12:54 
AnswerRe: Entity Framework Core 6 VARCHAR(MAX) Pin
Victor Nijegorodov8-Dec-22 18:24
Victor Nijegorodov8-Dec-22 18:24 
GeneralRe: Entity Framework Core 6 VARCHAR(MAX) Pin
Kevin Marois9-Dec-22 11:47
professionalKevin Marois9-Dec-22 11:47 
GeneralRe: Entity Framework Core 6 VARCHAR(MAX) Pin
jschell12-Dec-22 10:35
jschell12-Dec-22 10:35 
QuestionSOLVED - Pivot a result set Pin
Richard Andrew x6428-Nov-22 5:46
professionalRichard Andrew x6428-Nov-22 5: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 21:24
mveRichard Deeming28-Nov-22 21:24 
QuestionTSQL - JOIN cancels out my date filter Pin
jkirkerx27-Nov-22 13:53
professionaljkirkerx27-Nov-22 13:53 
AnswerRe: TSQL - JOIN cancels out my date filter Pin
Graham Breach27-Nov-22 21:38
Graham Breach27-Nov-22 21:38 
GeneralRe: TSQL - JOIN cancels out my date filter Pin
jkirkerx28-Nov-22 6:32
professionaljkirkerx28-Nov-22 6:32 
GeneralRe: TSQL - JOIN cancels out my date filter Pin
jschell28-Nov-22 10:44
jschell28-Nov-22 10: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 9:15
professionaljkirkerx21-Nov-22 9:15 
AnswerMaybe this is a bad idea, so I abandoned it. Did a work around instead. Pin
jkirkerx21-Nov-22 9:35
professionaljkirkerx21-Nov-22 9: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 10:29
Graham Breach21-Nov-22 10:29 
GeneralRe: TSQL - Create a JOIN, knowing that it may not exist, but show the initial records at least instead of nothing [solved] - May run with this Pin
jkirkerx21-Nov-22 11:04
professionaljkirkerx21-Nov-22 11:04 
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
Richard Deeming21-Nov-22 22:02
mveRichard Deeming21-Nov-22 22:02 
GeneralRe: 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
jkirkerx22-Nov-22 6:58
professionaljkirkerx22-Nov-22 6:58 
QuestionOrder by several static string values, error "Conversion failed when converting the varchar value 'FX' to data type int" Pin
jkirkerx14-Nov-22 10:44
professionaljkirkerx14-Nov-22 10:44 
AnswerRe: Order by several static string values, error "Conversion failed when converting the varchar value 'FX' to data type int" [sort of solved] Pin
jkirkerx14-Nov-22 11:29
professionaljkirkerx14-Nov-22 11:29 
GeneralRe: Order by several static string values, error "Conversion failed when converting the varchar value 'FX' to data type int" [sort of solved] Pin
jsc4222-Nov-22 10:31
professionaljsc4222-Nov-22 10:31 
GeneralRe: Order by several static string values, error "Conversion failed when converting the varchar value 'FX' to data type int" [sort of solved] Pin
jkirkerx22-Nov-22 10:50
professionaljkirkerx22-Nov-22 10:50 
GeneralRe: Order by several static string values, error "Conversion failed when converting the varchar value 'FX' to data type int" [sort of solved] Pin
jsc4222-Nov-22 23:26
professionaljsc4222-Nov-22 23:26 
GeneralRe: Order by several static string values, error "Conversion failed when converting the varchar value 'FX' to data type int" [sort of solved] Pin
jkirkerx23-Nov-22 6:11
professionaljkirkerx23-Nov-22 6:11 

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.