Amongst a list of T_SQL for date manipulation, I am sure you will find one that meets your objective in this blog posting by Lynn Pettis

https://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx

In additiion to GilaMonster's comments, and the database is configured as decribed.

Do the two tables in question have any indexes? If so statistics will be automatically created for them....

MIght I suggest that you examine using the OUTPUT clause, which is much easier to code for multiple rows being insterted/updated/deleted than a trigger.

Use Books On Line it has a...

Right now with the employment market as it is ..what is most important is EXPERIENCE, EXPERIENCE, EXPERIENCE. Many firms I am aware of, treat MS certification as oh well,...

A slight modification of your code from:

DECLARE @P_FECHADIAYER datetime

select dateadd(dd, datediff(dd, 0, Getdate()) - 01, 0)

To:

SET @P_FECHADIAYER = dateadd(dd, datediff(dd, 0, Getdate()) - 01, 0)

--

--following just to display result...

removed by submiitter

Do not know if this will help you, but have you examined CHARINDEX function? For example:

DECLARE @dcv1_FieldValue VARCHAR(10)

DECLARE @N INT

DECLARE @Next INT

SELECT @dcv1_FieldValue = '620..00'

SET @N = CHARINDEX('.',@dcv1_FieldValue,1)

SELECT @N

SET...

Fields!ABC.Value - appears to be ACCESS coding ... you sure...

If you can not modify the tables then you might consider creating a parameterized stored procedure , true you would have to pass the values to the procedure, but that...

Have not had any problems, such as forum is down ... not in the last 6 months

skailey

If those worked for you visit Lynn Pettis blog on SSC and learn a great deal more on some neat datetime handling T-SQL

https://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx

Since both are datetime in a equality statement (=) you will want to compare them without considering time ... that is using just the date.

Have you attempted that, and did...

If I understand you correctly these 2 fields are both datetime

ON a.COD_DIM_CALENDARIO_FEC_TASACION = b.COD_DIM_CALENDARIO

is that correct?

If so you, are making a comparision up to and including milliseconds ...

have you...

Prehaps these will get you started (Copied from blog posting by Lynn Pettis)

select dateadd(qq, datediff(qq, 0, @ThisDate), 0) -- Beginning of this quarter (Calendar)

select dateadd(qq,...

These 2 blog poast might help you to learn how it works on 2005 & 2000

http://blogs.msdn.com/sqlpbm/archive/2008/07/04/using-pbm-against-sql2k-and-sql2k5.aspx

http://blogs.msdn.com/sqlpbm/archive/2008/07/04/using-pbm-against-sql2k-and-sql2k5.aspx