J Livingston SQL (9/10/2016)

---

6th Generation Intel(R) Core(TM) i7-6700 / 16GB DDR4 /2TB 7200 rpm Hard Drive + 32GB M.2 SSD Cache

Microsoft SQL Server 2016 Developer Edition (64-bit) on Windows...

WayneS (9/9/2016)

---

J Livingston SQL (9/9/2016)

---

feeling pleased (for the minute!)

off the shelf tower.....

6th Generation Intel(R) Core(TM) i7-6700 Processor (8M Cache, up to 4.0 GHz)

16GB (2x8GB) 2133MHz DDR4 Non-ECC 1 SR

2TB...

Alan.B (9/9/2016)

---

I just spent 5 minutes trying to figure out whey this INSERT statement was failing:

CREATE TABLE dbo.MyTable

(

SocialAdvertisingDimAdKey int IDENTITY(1,1) NOT NULL,

...

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...