Luis Cazares (5/3/2016)

---

Ray K (5/3/2016)

---

Eirikur Eiriksson (5/3/2016)

---

Alan.B (5/3/2016)

---

Eirikur Eiriksson (5/3/2016)

---

Alan.B (5/3/2016)

---

I think this is a common problem in the data world for sure.

It all comes down to self-awareness and...

is as meaning less as errors come, possibly a permission missing?

😎

Alan.B (5/3/2016)

---

Eirikur Eiriksson (5/3/2016)

---

Alan.B (5/3/2016)

---

I think this is a common problem in the data world for sure.

It all comes down to self-awareness and communication. Knowing your strengths, weaknesses and...

jasona.work (5/3/2016)

---

One of the Devs I work with has an interesting issue. When he tries to deploy an SSIS project to the catalog, on one particular server, the deploy...

Alan.B (5/3/2016)

---

I think this is a common problem in the data world for sure.

It all comes down to self-awareness and communication. Knowing your strengths, weaknesses and limitations, then knowing...

The question or challenge must then be how to invoke...

First of all this topic is good, dead centre (bulls eye to the Americans) and very relevant! It goes in line with what I preach/practice "ascoltare vale piu di tante...

Ray K (5/3/2016)

---

Ray K (5/3/2016)

---

djj (5/3/2016)

---

Phil Parkin (5/3/2016)

---

Ed Wagner (5/3/2016)

---

Lynn Pettis (5/3/2016)

---

Luis Cazares (5/3/2016)

---

Ed Wagner (5/3/2016)

---

Lynn Pettis (5/3/2016)

---

Lynn Pettis (5/3/2016)

---

Some people should not be allowed any where near a database...

Depends on what tolerance you have for a downtime, easiest would...

Phil Parkin (5/3/2016)

---

Jeff Moden (5/3/2016)

---

djj (5/3/2016)

---

Had a "discussion" today. Developer asked I push a couple stored procedures. No problem, this happens all the time. Looked at the SP's...

Quick suggestion, add DISTINCT to the select otherwise the two data/entity nodes will always produce duplicate output

😎

DECLARE @XMLXML = '<xml as above>'

DECLARE @sql nvarchar(max) =

'SELECT DISTINCT '

+(

SELECT ',''' + T.FieldValue+...

Quick suggestion (similar to what's already posted)

😎

;WITH SAMPLE_DATA (CUST_NUMBER,CASH_DRWR_DATE,CONTR_DATE) AS

(SELECT

CUST_NUMBER

,CONVERT(DATETIME,CASH_DRWR_DATE,121)

,CONVERT(DATETIME,CONTR_DATE,121)

FROM (VALUES

(100027,'2014-04-11 00:00:00.000','2014-05-04 00:00:00.000')

,(100027,'2014-05-05 17:17:46.000','2014-07-04 00:00:00.000')

,(100027,'2014-05-05 17:18:02.000','2014-05-04 00:00:00.000')

,(100027,'2014-05-08 17:21:38.000','2014-06-04...

Rod at work (5/2/2016)

---

The subject line says it all. I'm testing something in an UPDATE trigger. Basically, I'd like to do a printf() type of thing. I created the trigger,...

mkaresh85 (5/2/2016)

---

Hi SQL experts,

I am working on our product bug which reports problem in automatic creation of few dynamic tables with following error: [SQLServer]Column\, parameter\, or variable #002322: Cannot specify...

First thing I would do would be running

DBCC CHECKDB ('MyDB') WITH NO_INFOMSGS ALL_ERRORMSGS;

😎

I find the SQLSTATE 42000 slightly odd, IIRC that's a "Syntax error or access violation".