Database for testing - problems with updates

[Software]

Hello

we try to use a database for a test. We write into a table the date of two days ago and of three days ago. These dates are our variables in the test.

 

The problem: The dates are not updated (example: variables two days ago 14/7 and 15/7, variables of today 14/7 and 15/7, but it should be 16/7 and 17/7)

 

Our stored procedure:

USE [DATABASE]
GO
/****** Object:  StoredProcedure [dbo].[Listsearch_Report_Dates_Procedure]    Script Date: 19.07.2017 12:25:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[Listsearch_Report_Dates_Procedure]
AS
BEGIN

Update dbo.Listsearch_Report_Dates

Set Vorgestern = CONVERT(VARCHAR(6), getdate()-2, 4), 
Vorvorgestern = CONVERT(VARCHAR(6), getdate()-3, 4) 

select * from Listsearch_Report_Dates
END

 

 

[Elena]

Hi Matthias,

Thanks for the shared details. 

Please let me know if you have clicked on the Update button (please see screenshot) and what the result was. Also did you run the test? Was it taking the correct values in runtime? 

Please also let me know what type is the database you have decided to use in case none of the above works as expected. 

Thanks in advance! 

Regards,
Elena Tsvetkova
Progress Telerik

 

[Software]

Now we use another database and it works. It is quite difficult to explain, because our settings are the same and we didn't change something in our configuration.

[Elena]

Hi Matthias,

Thanks for the feedback. I am glad to know the issue was resolved somehow although it is not quite clear. Though I suspect it might something related to the initial database if it was corrupted somehow. 

Anyways, I hope you will not face that inconsistent behavior again! 

Regards,
Elena Tsvetkova
Progress Telerik