richard.wanamaker (11/24/2016)

---

Running this:

INSERT INTO [dbo].RichTest

SELECT doc.col.value('(.)[1]', 'nvarchar(50)')

FROM @RichTests.nodes('/macs/mac') AS doc(col)

WHERE NOT EXISTS (SELECT 1 FROM [RichTest] WHERE [Name] = doc.col.value('(.)[1]', 'nvarchar(50)')

Getting this:

System.Data.SqlClient.SqlException: Database 'Doc' cannot be opened because...

Gazareth (11/24/2016)

---

Eirikur Eiriksson (11/24/2016)

---

Gazareth (11/24/2016)

---

BWFC (11/24/2016)

---

ThomasRushton (11/24/2016)

---

BLOB EATER (11/24/2016)

---

GilaMonster (11/24/2016)

---

The office kitchen also caters to stranger tastes, with 3 types of tea...

RonKyle (11/23/2016)

---

In most cases there isn't one. I would certainly never use an SSN for this. But that doesn't mean that...

No cooler? No sparkling water?? No bubbly wine??? No waiter???? No sommelier?????

😎

Hugo Kornelis (11/24/2016)

---

polytropic2310 (11/23/2016)

---

Hello Hugo,

Hugo Kornelis (11/23/2016)

---

Well, I can tell with 100% certainty that there are at least two differences:

1. The statistics on the data in UAT are different from...

Gazareth (11/24/2016)

---

BWFC (11/24/2016)

---

ThomasRushton (11/24/2016)

---

BLOB EATER (11/24/2016)

---

GilaMonster (11/24/2016)

---

The office kitchen also caters to stranger tastes, with 3 types of tea (two black tea...

And what value are you passing for the @shift variable?

😎

Nomvula (11/24/2016)

---

hi

I've created this query for my ssrs report but i''m getting the error:

Invalid length parameter passed to the LEFT or SUBSTRING function

I want to be able to select multiple...

Can you post the DDL for the table DataXYZ.dbo.DataXYZ_GeoLoc_Input?

😎

The main problem is the data conversion method used in the views.

, CAST('' AS xml ).value('sql:column("x") cast as xs:decimal ?', 'decimal(24,12)')...

Steve Jones - SSC Editor (11/23/2016)

---

robert.sterbal 56890 (11/23/2016)

---

What is on your menu for Thanksgiving?

Can you share any recipes?

Our family will be having Thanksgiving at my wife's parents with turkey, gravy,...

sgmunson (11/23/2016)

---

Just curious if there's any chance that the clock on the problem server is not within a minute or two of the SQL Server clock. If there's...

polytropic2310 (11/22/2016)

---

Hello,

What parameters can have an impact on "number of logical reads" ?

UAT and PROD environments are supposed to be the same but "number of logical reads" is huge for...

Hugo Kornelis (11/22/2016)

---

Hmmm, that is a very...

Are your drivers up do date?

😎

Jeff Moden (11/20/2016)

---

Eirikur Eiriksson (11/20/2016)

---

I'm strictly for the full most practical normalisation with one exception, carrying forward a very carefully selected keys such as Invoice-->InvoiceLine-->InvoiceLineDetail(InvoiceID) where, at the cost of...