Shulou(Shulou.com)05/31 Report--

How to query consecutive date records in sqlserver? for this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

Insus.NET tried to write a program and tested it, and you can get the expected results. The SQL code can be used for reference and learning. The copy code is as follows:-- create a temporary table that will store records of consecutive dates CREATE TABLE # temp (IDD VARCHAR (10), SDATE DATETIME) DECLARE @ sD DATETIME-start date DECLARE @ eD DATETIME-end date-- in the record, find the start and end dates SELECT @ sD = MIN ([SDATE]), @ eD = MAX ([SDATE]) FROM [TT] DECLARE @ N INT = 0-declare a variable Store cumulative records-circular date WHILE (@ sD = 3)-determine whether it is greater than or equal to 3 INSERT INTO # temp SELECT [IDD], [SDATE] FROM [TT] WHERE [SDATE] BETWEEN DATEADD (day,-@N,@sD) AND @ sD-date plus 1 day SET @ sD = DATEADD (day,1,@sD) SET @ N = 0-initialize to 0 END END-list eligible records SELECT * FROM # temp

This is the answer to the question about how to query consecutive date records in sqlserver. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.