Hello Gift

Thanks for your reply, also i have one question ,do i must uninstall and reinstall SQL server completly or can i reinstall only the services for reporting.

I can do...

Hello Comunity

Many tahnks for your reply

Luis Santos

Hello comunity

It´s curious because nobody answer me.

Ok, maybe my questions are obvious, but it´s strange that nobody send me a reply.

i repeat my doughts:

1-It is recommended to uninstall X86 before...

Hello Antonio

Thanks for your reply they work fine

Luis Santos

Hello comunity

I read on google, many persons that have the same problem, but any response reolve them.

Could someone give me a little help.

Note : my OS is Windows Vista an...

Hello Jack

I make what you said in your last reply , but now i have an another error:

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for...

Thanks Jack

I will try

Luis Santos

Hello Lynn

Many thanks for your reply, now i understand better your ideia.

The year is provided by the user as just the year.

But using your suggest parameters, i think that i...

Hello again

Thanks for everybody that have make suggestions to help me. I write my TSQL in another way:

select distinct

ml.conta as 'Integração',

/*(select top 1 descricao from pc where pc.conta=ml.conta and pc.ano...

Hello Lynn

thanks for your reply.

I test my tsql code with some index that you mencioned, but the maximum performance for this TSQL is about 6,30 minutes. Is too much

Also, i...

Hello Matt

I make the calc on a small calculator, and you have reason about your result, but i solve my problem using :

round(round(cast(etiliquido*1.105 as decimal(10,2))/1.21,3),2)

Many thanks

Luis Santos

Hello comunity

nobody have an ideia ?

thanks

Luis Santos

Hello Karl

thanks for your reply, they work fine

bye

Luis Santos

Hello John

Thanks for your reply.

I wil send to you 4 scripts

1- generate FO table

2-generate ML table

3-INSERT data into FO

4-INSERT data into ML

I thinks that´s you will need to solve...

Hello John

Thanks for your reply.

I will attach a WORD file with print screen of my invoice and there movment in accountancy.

I thinks is better for you see the problem.

Many...