Hello Steve

Thanks for your reply, i will go to test it.

Best Regards,

Luis Santos

Hello Dohsan

i understand your doubt but i need the range of my invoiceheader dates .

without this range all invoices are appear.

In pratice, and i don´t know if it is possible,...

Hello Sergiy

Thanks for your reply, on arithmetic operators i don´t have dought, because if i select a numeric field everything done.

But if i choose a varchar field, this snippet don´t...

Hello again Eirikur

Thanks a lot, this is exactly what i need, great help.

Many thanks again.

Best regards,

Luis Santos

Hello Eirikur

I was also considering using a "CROSS JOIN" the problem was how to do this.

with your help and your example, I think it will be easier I can get...

Hello J Livingston

i try to create these 2 temporary table, i hope you understand what i pretend.

CREATE TABLE #article(ref VARCHAR(18))

insert INTO #article(ref)

SELECT 'LY E67F'

CREATE TABLE #BrightGroup(ref varchar(18), GROUPCod VARCHAR(2), VALUE...

Hello Jeff

First thanks for your reply and also about all the advice.

I will read more carefully the article to try to understand it, because it is very important to me...

Hello again

I found this interesting code to avoid cursor, but i still have a problema because i cannot repeat 2 INSERT for each diferente PRODUCTID.

This is the code:

IF OBJECT_ID('Pr_ProductSalesAlternativeReport', 'p')...

Hello again

I found this interesting code to avoid cursor, but i still have a problema because i cannot repeat 2 INSERT for the same PRODUCTID.

This is the code:

IF OBJECT_ID('Pr_ProductSalesAlternativeReport', 'p')...

Hello again

Sorry i have make a misture,

For referente A1 the valeu is 1000/25=4 years , tem the result expectativa is:

A1 250 25

A1 250 25

A1 250...

Hello

Many thanks for your replies, this is a small example only with 2 diferentes references:

SELECT 'A1'[ref], 2010 [year],4 [numberyear],0 [nrreint],0 [naoreint],0[degress],

1400[tabela],25[tax],25[taxamaxima],1000[PriceValue],0[evaldepact],0[ereintact],25[taxAmtAno]

UNION ALL

SELECT 'A2'[ref], 2004 [year],10 [numberyear],0 [nrreint],0 [naoreint],0[degress],

1400[tabela],10[tax],10[taxamaxima],2000[PriceValue],0[evaldepact],0[ereintact],10[taxAmtAno]

Result FOR Ref...

Hello Lowell

Thanks for your reply.

Best regards,

Luis Santos

Hello comunity

I found the problem and solve the situation because i not write the correct name field to Update.

the correct name is eftaxam_a and not ftaxamt_a.

my apologies.

Best regards,

Luis Santos

Hello Kevin

This is the script to reproduce the problem:

--Invoice Header

CREATE TABLE dbo.ft (ftstamp VARCHAR(25), ndoc NUMERIC(3,0), fno NUMERIC(10,0), tipodoc NUMERIC(1,0), anulado BIT)

INSERT INTO dbo.ft (ftstamp, ndoc, fno, tipodoc, anulado)

VALUES ('LIL14070164865,029464325',...

Hello Kevin

First thanks for your advise.

I will go attach a jpg file with my invoice line, and also the accountancy movment.

Of course the values are correct, but i need this...