sifar786 (7/6/2014)

---

Thanks for the links mate. 🙂

BTW, i am currently looking at this Cube Tutorial. But it doesnt explain how to create and deploy cubes made from a single table....

sifar786 (7/5/2014)

---

the above queries work fine in sql server now, but donot know how to automate job schedule to scan network folder for csv files and run those queries on...

is this correct....

UNION ALL

SELECT t.*, (substring(t.[week],3,4))*1 as iYEAR,

''SPAIN'' as [sCOUNTRY], ''EURO'' as [sCHAR],

IIf( t2.first_week_on_sale = 1 and t2.weeks_on_sale <=52,

((((substring(t.[week],3,4) - 2011) * 52) + right(t.[week],2)) - t2.first_week_on_sale) + (1...

I am trying to run a UNION ALL query in SQL SERVER 2014 on multiple large CSV files - the result of which i want to get into a table...

no probs...send me a PM ....if I get anywhere I'll obfuscate the details for you if...

can you provide some sample data in a readily consumable format for DATABASE_SPAIN_EURO.CSV/DATABASE_FRANCE_EURO.CSV ?

do you have the data before it was pivoted/crosstabbed?

eg

emp1,jan,200

emp1,feb,220

emp2,jan,300

emp2,mar,305

just a thought and maybe provide flexibility if you require....

IF OBJECT_ID('tempdb..sort') IS NOT NULL DROP TABLE sort;

CREATE TABLE #sort

(sortID int not null,

sortvalue int not null);

INSERT #sort VALUES (1, 2323),(2, 1236),(3,...

what spec hardware you running Lynn.....?[/quote]

Dell M4600 laptop, dual CORE...

if you have little time to prepare this report and you have never used SSAS...then this might not be the right time to start SSAS

maybe if you provided some data...

.[/quote]

I agree. With 3,250,325 rows in the main table mine ran in about 3 seconds.

[/quote]

what spec hardware you running Lynn.....?

Arno Ho (7/3/2014)

---

Hi,

Thank you for all your answers and proposed solutions

I applied that Lynn

With my method it takes 15 minutes and 12 minutes with the Lynn solution

I think I'll...

in my opinion I think what you are trying to do from excel is potentially flawed....you say that you have over 100M rows to analyse.

if you can create the necessary...

on...

Luis Cazares (7/2/2014)

---

There's no need to read the table trice.

WITH CTE AS(

SELECT ID,

Orderamt,

...