Database

DBCC CHECKDB ('Your DB Name') WITH NO_INFOMSGS;
GO

SELECT DATABASEPROPERTY ('Your DB Name', 'IsAutoClose');
GO

ALTER DATABASE database_name
SET AUTO_CLOSE OFF;
GO

where (payment.payment_date < 'two month ago from now')

DECLARE @Today date = GetUtcDate();
DECLARE @CutoffDate date = DateAdd(month, -2, @Today);

SELECT
    *
FROM
    person
WHERE
    Not Exists
    (
        SELECT 1
        FROM payment
        WHERE payment.national_number = person.national_number
        And payment.payment_date > @CutoffDate
    )
;

Eddy Vluggen wrote:

Bastard Programmer from Hell

SELECT person.*
FROM person
LEFT OUTER JOIN payment
ON person.national_number = payment.national_number
AND payment_date > 'two month ago from now'
WHERE payment_date IS NULL

SELECT employee_number FROM employees WHERE employee_number REGEXP ('[0-9]');

SELECT MAX(employee_number) FROM employees WHERE employee_number REGEXP ('[0-9]');

Member 10949986 wrote:

it means i would have to create another table for the unread messages,right?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]