Database

Lior S wrote:

basically the main slowing reason is the UPDATE procedure since it is searching in more then 5 million records to fit to the conditioned row for the update.

Data Source=(local);Initial Catalog=MIDAS;Integrated Security=true;
Data Source=seafire;Initial Catalog=MIDAS;Integrated Security=true;
Data Source=<ipaddress>;Initial Catalog=MIDAS;Integrated Security=true;

oskardiazdeleon wrote:

i.e

datediff(@dateRange, getdate())=0

oskardiazdeleon wrote:

Any Ideas?

CASE @dateRange WHEN 'dd' THEN DATEDIFF(dd, GETDATE(), @someOtherDate) 
                WHEN 'ww' THEN DATEDIFF(ww, GETDATE(), @someOtherDate)
                WHEN 'yy' THEN DATEDIFF(yy, GETDATE(), @someOtherDate)
                ELSE 0 END

CREATE FUNCTION DateDifference(@dateRange CHAR(2), @startDate DATETIME, @endDate DATETIME)
RETURNS INT
AS
BEGIN
RETURN CASE @dateRange WHEN 'dd' THEN DATEDIFF(dd, @startDate, @endDate) 
                       WHEN 'ww' THEN DATEDIFF(ww, @startDate, @endDate)
                       WHEN 'yy' THEN DATEDIFF(yy, @startDate, @endDate)
                       ELSE 0 END
END

SELECT dbo.DateDifference(@dateRange, @someDate, GETDATE())

CREATE PROCEDURE MyFirstProc @cParam varchar(10)
AS
PRINT 'MyFirstProc ' + @cparam
EXEC MySecondProc @cparam
GO

CREATE PROCEDURE MySecondProc @cTest varchar(20)
AS
PRINT 'This is in MySecondProc ' + @cTest
GO

MyFirstProc testing<br />
This is in MySecondProc testing

CREATE TRIGGER UPDATE_REST1
ON [DBO].[FINTRADE]
FOR UPDATE
AS

IF UPDATE(FTRIDPAYMENT)
  UPDATE FINTRADE
    SET Z_YPOLOIPO= (SELECT ISNULL(I.TOTLAMOUNT,0) - ISNULL(PLH.TOTLAMOUNT,0) AS Z_YPOLOIPO
                     FROM INSERTED I, FINTRADE PLH
                     WHERE I.FTRIDPAYMENT=PLH.ID)
    FROM FINTRADE F, INSERTED I
    WHERE F.ID=I.ID

IF UPDATE(TOTLAMOUNT)
  UPDATE FINTRADE
  SET Z_YPOLOIPO= (SELECT ISNULL(PAR.TOTLAMOUNT,0) - ISNULL(I.TOTLAMOUNT,0) AS Z_YPOLOIPO
                   FROM INSERTED I, FINTRADE PAR
                   WHERE PAR.FTRIDPAYMENT=I.ID)
  FROM FINTRADE F, INSERTED I
  WHERE F.FTRIDPAYMENT=I.ID