Thanks for this, now the only thing missing is the exact format of the XML, can you please post an example?

😎

This approach seems overly complicated to me. Can you please post the DDL (create tables), sample data as an insert statement and the expected output?

😎

Quick suggestion, use Ola Hallengren's index maintenance scripts, work like a charm.

😎

ChrisM@Work (9/6/2016)

---

Sean Lange (9/6/2016)

---

Luis Cazares (9/6/2016)

---

Sean Lange (9/6/2016)

---

I tried my hand at curing my own bacon for the first time. It came out of the cure Saturday morning and hit...

Can you please post the DDL (Create table), sample data as an insert statement and the expected results?

😎

Here is one way of doing this, the output is self-explanatory, uses the OBJECTPROPERTY function and the sys.sql_expression_dependencies view.

😎

-- EE Quick Static Code Analysis

SELECT

SM.object_id ...

Quick thought, either do year-week or year-month, the two are incompatible

😎

Congrats, good stuff and you are most welcome.

😎

Simply add the grouping as the first CTE

😎

USE TEEST;

GO

SET NOCOUNT ON;

;WITH DEMO(ID,FromTime,ToTime) AS

(

SELECT

ID

...

Quick suggestion, update the VS to the latest release before the installation, had similar/same problem on one of my workstations and after updating the VS with all the things applicable...

This code will return the interval in the format of DD:HH:MM:SS

😎

USE TEEST;

GO

SET NOCOUNT ON;

;WITH DEMO(ID,FromTime,ToTime) AS

(

SELECT

ID

...

Good point:pinch:, obviously the TIME data type isn't fit for purpose if either a single interval or the...

Quick thought, the time calculation is not correct, the second result sould be 02:30:21 so there is an extra minute there in the results.

😎

Here are three different methods

USE TEEST;

GO

SET NOCOUNT...

You are merging into the LocDisplay table and that's where the error originates

😎

merge into LocDisplay as T

using (

select LocCode, PlaneCode, LocName, SomeCode

from [Loc] as S

cross apply (select distinct SomeCode from...

Do you have any index maintenance jobs running...