Thanks a lot for ur time too Flo, guess the last thing i can do when someone is helping, is give some information =D

Answering your question.

The main purpose...

Im attaching an excel file with the 4 main tables of the process, and some data.

is that useful?, maybe was a wrong choice excel D:

--

Damn, i had some trouble...

Awww sorry for the delay, very nice deductions of the data Florian, really, ill add some observations to it.

IF (OBJECT_ID('VW_DET_ALM_POR_TIENDA') IS NULL)

BEGIN

CREATE TABLE VW_DET_ALM_POR_TIENDA

(

...

36 rows, why?

I know it can be significantly improved, but im still learning XD, i add the code here, and the sql file in atachments for just in case.

the tables that...

Aww im sorry i didnt checked the file i saved, my mistake,

now i send the plan of the whole store procedure that i execute, the final result is...

:w00t: i didnt know about that feature XD,

im ataching the plan as u requested.

txs a lot for ur time guys =)

For sure.

the querys i use r those

SET @INV_INICIAL = (select ISNULL(sum(EXTDCOST),0) FROM VW_DET_ALM_POR_TIENDA

WHERE month(docdate)= @invInicialMES

AND year(docdate)=@invInicialANIO

AND USCATVLS_3 = @DEPARTAMENTO

AND USCATVLS_2 = @DIVISION

--AND USCATNUM = 3

AND @TIENDA =...

Yeah, i did it , and it reduced the execution time like 6 of 30 seconds, and thats cool.

And since the ERP tables keep growing like roaches, i think those...

Txs for the replies guys, but guess ill need to looks for another way, since i found this:

* You can not create an index on a...

GSquared (4/1/2009)

---

You won't be able to create an indexed view on that table. However, if you can index the columns you need on the tables, instead of the view,...