Thanks for the quick replies.

I was testing the query, and i didn't bother to put the order by so i didn't realize that if i put the order by clause,...

Thanks

I'll go with the first one, i'm just the programmer, the server administration it's someone else's work...

I'm just checking if there is something wrong with m database.

Thanks for the reply.

I'll do what you suggest and come back with the results, but how do i test the file IO in the second point?

I'll let the refactoring to...

So my only hope it's redesigning the query and remove the RBARs...

I'll see what i can do to solve this.

Thanks

Alright i need to do that, and thanks for the link to the Hidden RBAR. 🙂

But one thing i don't understand, why there's such difference between 2000 and 2005, if...

The same times 1,3 minutes....

Need to redesign the cursors, but i don't see how to ... 🙂

Thanks

The returning number it's aprox. 500, but it's not a fixed number, i just set the compatibility mode to 9, it was in the 8, and now it "only" takes...

Thanks

Like i wrote i didn't had the time to optimize the function...

But the main problem here it's why in 2000 only takes 11 seconds and now in the 2005 version...

Here it is...

I ran this commands:

DBCC DBREINDEX ('Calendario', ' ', 80)

UPDATE STATISTICS dbo.Calendario

DBCC SHOWCONTIG ('Calendario')

Results:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

DBCC SHOWCONTIG scanning 'Calendario' table...

Table: 'Calendario' (2019538278);...

Yes, but it's a big function and i didn't have the time to optimize.

CREAT FUNCTION [dbo].[Carga]

(

@DataHojeDATETIME,

@MinModelacaoINTEGER,

@MinFabricoINTEGER,

@MinExpedicaoINTEGER,

@IDREVINTEGER,

@IDSALINTEGER

)

RETURNS

@TabelaCargaPrevistaFabrico TABLE

(

DataDATETIME,

ValorRevDECIMAL(10,3),

ValorSalDECIMAL(10,3),

ValorTotDECIMAL(10,3)

)

AS

BEGIN

DECLARE

-- Cursor -- Valores Lidos da Tabela --

@DataTempDATETIME,

@DataInicio DATETIME,

@DataFimDATETIME,

@SeccaoINTEGER,

@HorasTotal DECIMAL(10,3),

@HorasRevDECIMAL(10,3),

@HorasSalDECIMAL(10,3),

--

@RowActualINTEGER,

@IntervaloINTEGER,

@ValorDiaDECIMAL(10,3),

-- Cursor Data...

Thanks once again.

But the code that you posted doesn't solve my problem, because i need to know the correct order of the columns, if you look to the R60 how...

No one 🙁

Hehehe sorry about that... Forget the log file structure. :ermm:

This's what happen when trying to do several things at the same time.

1. The OrderRoute it's the same of the Order,...

I though in another solution, but in this one i can't get the route name correctly, according to the user selections...

IF OBJECT_ID('TempDB..#mytemptable2','U') IS NOT NULL

DROP TABLE...