Hi all. I'm sure this gets asked all the time, but it didn't jump out at me when I searched. I need something that will group by a field, and then concatenate all of the strings that get aggregat...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21048244.html
Zones:
MS SQL ServerDate Answered: 07/06/2004 Rating: 9.2 Views: 0
I have two tables:
CREATE TABLE `marks` (
`id_student` int(11) NOT NULL default '0',
`id_subject` int(11) NOT NULL default '0',
`mark` tinyint(4) NOT NULL default '0'
);
CREATE TABL...
http://www.experts-exchange.com/Database/MySQL/Q_21557470.html
Zones:
MySQL ServerDate Answered: 09/11/2005 Rating: 9.2 Views: 54
I am trying to restructure how dat is sitting in a table so that it can exist in a report better.
I have a table that has fields
Year
Inv_type
Str
sku
area
qty
I need to roll up this...
http://www.experts-exchange.com/Database/Oracle/Q_20435763.html
Zones:
OracleDate Answered: 12/31/2002 Rating: 6.2 Views: 21
Hi,
I was wondering if any body could please help me. I am trying to create a query using the following tables:
Client
ClientInterests
Interests
The client table has a clientID field ...
http://www.experts-exchange.com/Database/MySQL/Q_22025714.html
Zones:
MySQL ServerDate Answered: 12/03/2006 Rating: 8.4 Views: 0
Hi,
I have following query in Mysql which is using Group_Concat() function of mysql.
How to modify this query to work with Oracle and Mysql.
I do not want to write any PL/SQL function in Oracle....
http://www.experts-exchange.com/Database/Oracle/Q_22026623.html
Zones:
OracleDate Answered: 10/17/2006 Rating: 9.8 Views: 126
Hi all, I'm having an issue with the following query:
$sql = "SELECT v.vehicle_id,
v.transmission,
v.body_style,
v.doors,
v.drive_train,
v.engin...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/Q_22831208.htm...
Hi experts, I've been monitoring the following question: http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Databases/Q_24325145.html?cid=1066
and I would like to know...
http://www.experts-exchange.com/Database/MySQL/Q_24325956.html
I need a functional alternative to the group_concat function since its not possible for me to upgrade to 4.1 at this time.
Im creating a temporary table that stores all keyword_ids of all releva...
http://www.experts-exchange.com/Database/MySQL/Q_20955939.html
Zones:
MySQL ServerDate Answered: 04/19/2004 Rating: 9.4 Views: 4
Hi guys
Has anyone found a method in sqlserver 2000 to 'aggregate' strings in a Group By query. Like using 'Sum' for numerics...
e.g. table values:
cGroup cText
A L
A ...
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21265555.html
Zones:
MS SQL ServerDate Answered: 01/07/2005 Rating: 9.6 Views: 399
In mysql,
using group_concat()..we can concatenate column values from different rows..
Is there any equivalent function in SQL server..
I am not interested in stored procedures/functions.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21369689.html
Zones:
MS SQL ServerDate Answered: 04/19/2005 Rating: 8.6 Views: 140
