SQL Query to Concatenate text [duplicate]
Multi tool use
0
This question already has an answer here:
Concatenate one field after GROUP BY
1 answer
How to make a query with group_concat in sql server [duplicate]
4 answers
Simulating group_concat MySQL function in Microsoft SQL Server 2005?
9 answers
get a comma delimited string from rows [duplicate]
2 answers
I am trying to find the best way to consolidate the string in the fields that have the same value. Please look at the example below:
Table1:
Column1 | Column2 | Column3 | Column4
test1 test2 test3 string1
test1 test2 test3 string2
test4 test5 test6 string3
test4 test5 test6 string4
The result need to be inserted to Table2 like following:
Table2:
Column1 | Column2 | Column3 | Column4
test1 test2 test3 string1 string2
test4 test5 test6 string3 string4
I need to avoid Cursors please. Thank you.
Please note: I can not use the XML PATH.
The following query wouldn't work:
SELECT
m.Column1,m.Column2,m.Column3
, Column4 = STUFF((
SELECT ' ' + Column4
FROM dbo.Table1
FOR XML PATH(''), TYPE).value('.', 'varchar(max)'), 1, 1, '')
FROM dbo.Table1 m
sql
sql-server sql-server-2008 asked Nov 20 at 21:33
user3314399
1371720
marked as duplicate by Zohar Peled sql
Users with the sql badge can single-handedly close sql questions as duplicates and reopen them as needed.
StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;
$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');
$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
Nov 20 at 21:38
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
|
show 10 more comments
0
This question already has an answer here:
Concatenate one field after GROUP BY
1 answer
How to make a query with group_concat in sql server [duplicate]
4 answers
Simulating group_concat MySQL function in Microsoft SQL Server 2005?
9 answers
get a comma delimited string from rows [duplicate]
2 answers
I am trying to find the best way to consolidate the string in the fields that have the same value. Please look at the example below:
Table1:
Column1 | Column2 | Column3 | Column4
test1 test2 test3 string1
test1 test2 test3 string2
test4 test5 test6 string3
test4 test5 test6 string4
The result need to be inserted to Table2 like following:
Table2:
Column1 | Column2 | Column3 | Column4
test1 test2 test3 string1 string2
test4 test5 test6 string3 string4
I need to avoid Cursors please. Thank you.
Please note: I can not use the XML PATH.
The following query wouldn't work:
SELECT
m.Column1,m.Column2,m.Column3
, Column4 = STUFF((
SELECT ' ' + Column4
FROM dbo.Table1
FOR XML PATH(''), TYPE).value('.', 'varchar(max)'), 1, 1, '')
FROM dbo.Table1 m
sql
sql-server sql-server-2008 asked Nov 20 at 21:33
user3314399
1371720
marked as duplicate by Zohar Peled sql
Users with the sql badge can single-handedly close sql questions as duplicates and reopen them as needed.
StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;
$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');
$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
Nov 20 at 21:38
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
Do you have only two rows that match?
– Gordon Linoff
Nov 20 at 21:33
1
Investigate "group by" on the first three columns, and the use of STUFF... check out this answer: stackoverflow.com/questions/13647394/…
– pmbAustin
Nov 20 at 21:35
just another similar answer stackoverflow.com/questions/18910134/…
– morsik
Nov 20 at 21:36
Similar @morsik but for SQL Server they'll need this one: stackoverflow.com/questions/17591490/… which is mentioned in your post but as the third answer. MySQL was accepted.
– scsimon
Nov 20 at 21:37
1
And the list of dupes can get even bigger...
– Zohar Peled
Nov 20 at 21:41
|
show 10 more comments
0
0
0
This question already has an answer here:
Concatenate one field after GROUP BY
1 answer
How to make a query with group_concat in sql server [duplicate]
4 answers
Simulating group_concat MySQL function in Microsoft SQL Server 2005?
9 answers
get a comma delimited string from rows [duplicate]
2 answers
I am trying to find the best way to consolidate the string in the fields that have the same value. Please look at the example below:
Table1:
Column1 | Column2 | Column3 | Column4
test1 test2 test3 string1
test1 test2 test3 string2
test4 test5 test6 string3
test4 test5 test6 string4
The result need to be inserted to Table2 like following:
Table2:
Column1 | Column2 | Column3 | Column4
test1 test2 test3 string1 string2
test4 test5 test6 string3 string4
I need to avoid Cursors please. Thank you.
Please note: I can not use the XML PATH.
The following query wouldn't work:
SELECT
m.Column1,m.Column2,m.Column3
, Column4 = STUFF((
SELECT ' ' + Column4
FROM dbo.Table1
FOR XML PATH(''), TYPE).value('.', 'varchar(max)'), 1, 1, '')
FROM dbo.Table1 m
sql
sql-server sql-server-2008 asked Nov 20 at 21:33
user3314399
1371720
This question already has an answer here:
Concatenate one field after GROUP BY
1 answer
How to make a query with group_concat in sql server [duplicate]
4 answers
Simulating group_concat MySQL function in Microsoft SQL Server 2005?
9 answers
get a comma delimited string from rows [duplicate]
2 answers
I am trying to find the best way to consolidate the string in the fields that have the same value. Please look at the example below:
Table1:
Column1 | Column2 | Column3 | Column4
test1 test2 test3 string1
test1 test2 test3 string2
test4 test5 test6 string3
test4 test5 test6 string4
The result need to be inserted to Table2 like following:
Table2:
Column1 | Column2 | Column3 | Column4
test1 test2 test3 string1 string2
test4 test5 test6 string3 string4
I need to avoid Cursors please. Thank you.
Please note: I can not use the XML PATH.
The following query wouldn't work:
SELECT
m.Column1,m.Column2,m.Column3
, Column4 = STUFF((
SELECT ' ' + Column4
FROM dbo.Table1
FOR XML PATH(''), TYPE).value('.', 'varchar(max)'), 1, 1, '')
FROM dbo.Table1 m
This question already has an answer here:
Concatenate one field after GROUP BY
1 answer
How to make a query with group_concat in sql server [duplicate]
4 answers
Simulating group_concat MySQL function in Microsoft SQL Server 2005?
9 answers
get a comma delimited string from rows [duplicate]
2 answers
sql
sql-server sql-server-2008 sql
sql-server sql-server-2008 asked Nov 20 at 21:33
user3314399
1371720
asked Nov 20 at 21:33
user3314399
1371720
edited Nov 20 at 22:49
asked Nov 20 at 21:33
user3314399
1371720
asked Nov 20 at 21:33
user3314399
1371720
asked Nov 20 at 21:33
user3314399
1371720
1371720
marked as duplicate by Zohar Peled sql
Users with the sql badge can single-handedly close sql questions as duplicates and reopen them as needed.
StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;
$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');
$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
Nov 20 at 21:38
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
marked as duplicate by Zohar Peled sql
Users with the sql badge can single-handedly close sql questions as duplicates and reopen them as needed.
StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;
$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');
$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
Nov 20 at 21:38
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
Do you have only two rows that match?
– Gordon Linoff
Nov 20 at 21:33
1
Investigate "group by" on the first three columns, and the use of STUFF... check out this answer: stackoverflow.com/questions/13647394/…
– pmbAustin
Nov 20 at 21:35
just another similar answer stackoverflow.com/questions/18910134/…
– morsik
Nov 20 at 21:36
Similar @morsik but for SQL Server they'll need this one: stackoverflow.com/questions/17591490/… which is mentioned in your post but as the third answer. MySQL was accepted.
– scsimon
Nov 20 at 21:37
1
And the list of dupes can get even bigger...
– Zohar Peled
Nov 20 at 21:41
|
show 10 more comments
Do you have only two rows that match?
– Gordon Linoff
Nov 20 at 21:33
1
Investigate "group by" on the first three columns, and the use of STUFF... check out this answer: stackoverflow.com/questions/13647394/…
– pmbAustin
Nov 20 at 21:35
just another similar answer stackoverflow.com/questions/18910134/…
– morsik
Nov 20 at 21:36
Similar @morsik but for SQL Server they'll need this one: stackoverflow.com/questions/17591490/… which is mentioned in your post but as the third answer. MySQL was accepted.
– scsimon
Nov 20 at 21:37
1
And the list of dupes can get even bigger...
– Zohar Peled
Nov 20 at 21:41
Do you have only two rows that match?
– Gordon Linoff
Nov 20 at 21:33
Do you have only two rows that match?
– Gordon Linoff
Nov 20 at 21:33
1
1
Investigate "group by" on the first three columns, and the use of STUFF... check out this answer: stackoverflow.com/questions/13647394/…
– pmbAustin
Nov 20 at 21:35
Investigate "group by" on the first three columns, and the use of STUFF... check out this answer: stackoverflow.com/questions/13647394/…
– pmbAustin
Nov 20 at 21:35
just another similar answer stackoverflow.com/questions/18910134/…
– morsik
Nov 20 at 21:36
just another similar answer stackoverflow.com/questions/18910134/…
– morsik
Nov 20 at 21:36
Similar @morsik but for SQL Server they'll need this one: stackoverflow.com/questions/17591490/… which is mentioned in your post but as the third answer. MySQL was accepted.
– scsimon
Nov 20 at 21:37
Similar @morsik but for SQL Server they'll need this one: stackoverflow.com/questions/17591490/… which is mentioned in your post but as the third answer. MySQL was accepted.
– scsimon
Nov 20 at 21:37
1
1
And the list of dupes can get even bigger...
– Zohar Peled
Nov 20 at 21:41
And the list of dupes can get even bigger...
– Zohar Peled
Nov 20 at 21:41
|
show 10 more comments
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
IlIU UOmuVd BwZdc M4ZDy,at88ky GWMO8AUUcACRoX1mCDcjBp
Do you have only two rows that match?
– Gordon Linoff
Nov 20 at 21:33
1
Investigate "group by" on the first three columns, and the use of STUFF... check out this answer: stackoverflow.com/questions/13647394/…
– pmbAustin
Nov 20 at 21:35
just another similar answer stackoverflow.com/questions/18910134/…
– morsik
Nov 20 at 21:36
Similar @morsik but for SQL Server they'll need this one: stackoverflow.com/questions/17591490/… which is mentioned in your post but as the third answer. MySQL was accepted.
– scsimon
Nov 20 at 21:37
1
And the list of dupes can get even bigger...
– Zohar Peled
Nov 20 at 21:41