Database

Afzaal Ahmad Zeeshan wrote:

Learn more

WITH cteTally (N) As
(
    SELECT TOP 21 -- 15 weekdays + 6 weekend days
        ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) - 1
    FROM
        sys.objects
),
cteDays (TheDate) As
(
    SELECT
        DATEADD(day, -N, GetUtcDate())
    FROM
        cteTally
)
SELECT
    TheDate
FROM
    cteDays As D
WHERE
    ((DATEPART(dw, TheDate) + @@DATEFIRST) % 7) Not In (0, 1)
And
    Not Exists
    (
        SELECT 1
        FROM table1 As T
        WHERE T.inserteddate = D.TheDate
    )
ORDER BY
    TheDate DESC
;

SELECT employeename, departmentname, salary FROM employees WHERE departmentno = 10;

SELECT JobTicket_024.file_link, JobTicket_024.Project_Number
FROM JobTicket_024
WHERE (((JobTicket_024.file_link)=Replace([JobTicket_024]![file_link],"'\\52qjkl-as-004v\CE_Data\CE\CEC\oce_drawings'","'F:\CE\CE\CE Drawings'")));

SELECT file, file_link, Replace([file_link],'\52qjkl-as-04v\CE_Data\CE\CEC\oce_drawings','F:\CE\CE\CE Drawings') AS NewFile
FROM JobTicket_024

Ankit RS wrote:

Any ideas/solutions would be much appreciated.