Here is one way of doing it:

with MyCTE as (
    select EmployeeID, StartDate, EndDate, LAG(EndDate, 1, NULL) OVER (PARTITION BY EmployeeID ORDER BY StartDate) as PrevEndDate
    from...

You can do it like that:


select * from sysobjects where (name like = @Name OR @Name is null) or (type =@Type OR @Type is null)


There is a very little known feature that is called - Scalable shared databases.  It lets several servers use the same database if it is a read only database.  I...

Take a look it this URL - https://www.sqlskills.com/blogs/jonathan/extended-events-dmvs/  It contains all the information that you need in order to create such a query.

Adi

In that case, make sure that the specified path (D:\data) exists.  If it does exist check that there isn't another file there with the name EAMTEST_index.ndf.  Another thing that you can...

Try to change this part - D:\\Data\\EAMTEST_index.ndf to D:\\Data\EAMTEST_index.ndf (you have one extra \).

Adi

I know that this is probably not what you were expecting, but I don't update statistics of every table that had modifications.  I have daily job and weekly job that...

You can use the convert function with the third parameter - style. According to your example you should use style number 3:

create table #Demo (c char(8))

insert into #Demo (c)...

Again, I'm not sure that I understand you. Your table has no dates column and yet from your last respond it seems that you want to get the sum...

Sorry but I don't understand the last respond. What do you mean only opening hours? Datediff function can get 2 points of time and calculate the difference between...