pcofre

Santiago, Chile

metricarts.com

Age: 34

CEO of MetricArts http://www.metricarts.com MetricArts is a Chilean business intelligence consulting company focused on providing high-performance solutions to support decision-making process.

Jun
22
comment SQL Pivot Table with SUM
Brilliant and elegant answer
Jun
22
comment SQL Pivot Table with SUM
Just tried and it works. Which version of SQL is on your server?
Jun
22
revised SQL Pivot Table with SUM
edited body
Jun
22
comment SQL Pivot Table with SUM
I just added a couple of missing FROM in the second CTE. Let me know if now it works.
Jun
22
revised SQL Pivot Table with SUM
added 42 characters in body
Jun
22
answered SQL Pivot Table with SUM
Jan
30
awarded Nice Answer
Jan
6
awarded Yearling
Sep
30
awarded Explainer
Apr
6
answered SQL query sum()/join/order by/ - what's wrong?
Apr
6
answered PivotTable - Calculate value depending on combination of row labels
Mar
17
awarded Peer Pressure
Oct
8
awarded Enlightened
May
29
answered SQL 2008 Combining data from multiple rows with the same ID into one row
May
5
revised Selecting first and last day of 2 separate months only given MM-YYYY date
edited body
May
4
answered Selecting first and last day of 2 separate months only given MM-YYYY date
Apr
24
answered select count absences of employees on each day
Apr
22
answered need replace id_parent on name in SQL Server
Apr
20
answered How do I turn row data into column data?
Apr
17
comment Need multiple results from DB Query
@Mark - Do you mean that you need 3 columns returned with these specific names each one?
1 2 3 4 5