Database

WITH Dates
(
    EntryDate,
    EmployeeNumber,
    Status,
    Days,
    EmployeeCode,
    EmployeeName,
    DeptName,
    JobName,
    HOD,
    Supervisor
)
AS
(
    SELECT
        a.[DATE],
        a.EmployeeID,
        a.Status,
        1,a.EmployeeCode,a.EmployeeName,a.DeptName,a.JobName,a.HOD,a.Supervisor
    FROM
        tblEmployeeAttendance1 a

    WHERE
        a.[Date] between @StartDate and @EndDate and (a.status='AB' OR a.Status='O') AND datepart(dw,a.[Date]) NOT IN (1,7)
    -- RECURSIVE
    UNION ALL

    SELECT
        a.[DATE],
        a.EmployeeID,
        a.Status,
        CASE WHEN (a.Status = Parent.Status) THEN Parent.Days + 1 ELSE 1 END,
        a.EmployeeCode,a.EmployeeName,a.DeptName,a.JobName,a.HOD,a.Supervisor
    FROM
        tblEmployeeAttendance1 a
    INNER JOIN
        Dates parent
    ON
        datediff(day, a.[DATE], DateAdd(day, 1, parent.EntryDate)) = 0
    AND
        a.EmployeeID = parent.EmployeeNumber  where a.[Date] between @StartDate and @EndDate and (a.status='AB' OR a.Status='O') AND datepart(dw,a.[Date]) NOT IN (1,7)
)
SELECT * FROM Dates where days>=2 order by EmployeeNumber, EntryDate

John Robert Wilk wrote:

existing scheme for backing up data

John Robert Wilk wrote:

I'm not very confident

John Robert Wilk wrote:

. They now want to store some data in a database and whould like to store the
data in different database files in each of the shared network folders.

John Robert Wilk wrote:

My question is, is this even a remotely good idea.

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

loctrice wrote:

I guess when they wrote it that could never ever happen

Andrei Straut wrote:

avoid another This is failing dunno why plz provide codez

Andrei Straut wrote:

Oh, sorry for not making it clearer.