如何找到连续缺席的日子 [英] how to find continuous absent days

问题描述

我在编写存储过程时遇到问题，这些存储过程找到了连续的缺席天
chektime列显示用户在场
表如

i have problem to write stored procedure that find the continuous absent days
chektime column shows the user is present
table are as

CREATE TABLE [dbo].[CHECKINOUT](
    [USERID] [int] NOT NULL,
    [CHECKTIME] [datetime] NOT NULL,
    [CHECKTYPE] [nvarchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VERIFYCODE] [int] NULL,
    [SENSORID] [nvarchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WorkCode] [int] NULL,
    [sn] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 CONSTRAINT [aaaaaCHECKINOUT_PK] PRIMARY KEY NONCLUSTERED
(
    [USERID] ASC,
    [CHECKTIME] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

请帮助我
在此先感谢

plz help me
thanks in advance

推荐答案

您能发表到目前为止所尝试的内容吗?

没有人会为你做功课.

Can you post what you have tried so far?

Noone will do your homework for you.

这篇关于如何找到连续缺席的日子的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！