Comments on Rational Relational: Emulating MySQL’s GROUP_CONCAT() Function in SQL S...

It works but it causes some issues. The characters...

2011-12-12T11:07:10.189+02:00

It works but it causes some issues.
The characters &, <, and > are always entitized to &, <, and > respectively.

How do we avoid it?

Please reply

DECLARE @x varchar(8000) SELECT @x = COALESCE(@x+&...

2011-07-12T07:26:38.566+03:00

DECLARE @x varchar(8000)
SELECT @x = COALESCE(@x+', ','')+ISNULL(GROUPNAME,'') FROM [whims2].[dbo].[UM_TGROUP]
SELECT @x

How can i group_concat two columns using cross app...

2011-03-17T12:36:52.261+02:00

How can i group_concat two columns using cross apply?

For example,

select group_concat(DATA_TYPE) as data_types, group_concat(column_name) as column_names from information_schema.columns group by table_name

your help is much appreciated.

you need to account for no values - SELEC...

2009-11-06T23:08:16.962+02:00

you need to account for no values -

SELECT table_name,
case when LEN(column_names) > 0
then LEFT(column_names,LEN(column_names) - 1)
else '' end AS column_names
FROM (SELECT table_name,
(SELECT column_name + ',' AS [text()]
FROM information_schema.columns AS internal
WHERE internal.table_name = table_names.table_name
FOR xml PATH ('')
) AS column_names
FROM (SELECT table_name
FROM information_schema.columns
GROUP BY table_name) AS table_names) AS pre_trimmed;

thank you very much, worked like a charm

2009-07-24T21:07:46.012+03:00

thank you very much, worked like a charm

Thanks for the tip.

2008-11-29T00:19:00.000+02:00

Thanks for the tip.

Thanks for this, I just tried to integrate this in...

2008-11-09T19:36:00.000+02:00

Thanks for this, I just tried to integrate this into an SQL Server application I am working on. I will do some benchmarks next week to see if this actually improves performance.

Briefly what I am doing is the following:
I have a search interface that can return a few upto a couple thousand results. In practice I am only interested in displaying upto 50 (actually the user can also ask to get upto 1000 returned if he insists), however I am always expected to show a count of all possible results (total as well as grouped by one criteria).

The solution we found gave us the best performance was to just fetch the id's and to throw that into an IN statement that fetches the actual data to display (and then again in a second query that fetches the "reason" why something was included since we are searching way more fields than are displayed in the end).

Now my obvious worry is that I do not really want to fetch 1000 rows one at a time in the worst case. Then again it might not matter, since PHP will by default fetch the entire result set anyways and will just buffer them in the client. But its still an interesting excurs into some more advanced SQL Server constructs.