Topic: Time interval
Hello. I was tangled absolutely
There is such request
SELECT dbo. Payment. PaymentID, dbo. Payment. PaymentContractKod, dbo. WaterUser. WaterUserName, dbo. Payment. PaymentDate FROM dbo. Payment
INNER JOIN dbo. WaterUser ON dbo. Payment. PaymentContractKod = dbo. WaterUser. WaterUserKod
WHERE (dbo. Payment. RecType <> 2) AND (dbo. Payment. LangID = 0) AND (dbo. Payment. PaymentDate> = CONVERT (DATETIME, ' 2017-8-30 ', 102)) AND (dbo. Payment. PaymentDate <= CONVERT (DATETIME, ' 2017-9-30 11:59:59 PM ', 102))
In this time interval the request hangs up and kol-vom records in it of the order 700. It is necessary to change an interval started to deliver for example 2017-8-29 and less works on hurrah and in records in this case in times increases. I do not know as think.