Greg Edwards-268690 (6/2/2015)

---

Eirikur Eiriksson (6/1/2015)

---

That...

oops, quoted wrong post. Let me try again.

You could start here: http://lmgtfy.com/?q=microsoft+sql2016

Eirikur Eiriksson (5/29/2015)

---

A currently active thread: "I don't use any clustered indexes actually... all of mine are non-clustered..."

Sometimes I do wonder where things went wrong with MS and SQL documentation/references/best...

How about:

DECLARE @SomeString VARCHAR(50)

SET @SomeString = '132.135.3.100, fe90::bu54:e9z5:61a9:5003'

SELECT LEFT(@SomeString, CHARINDEX(',', @SomeString)-1) AS 127.0.0.1

, SUBSTRING(@SomeString, CHARINDEX(',', @SomeString) + 2, 25) AS [MAC]

SET @SomeString = '132.235.219.113, fe80::28d9:l69a:5bbd:gr2f'

SELECT LEFT(@SomeString, CHARINDEX(',',...

Lynn Pettis (5/29/2015)

---

select left(@TestStr,patindex('%,%',@TestStr) - 1);

I can't post the declare of the @TestStr with the ip and mac...

Alan.B (5/29/2015)

---

Haha. Would be even funnier if it weren't so...

Ed Wagner (5/27/2015)

---

GilaMonster (5/27/2015)

---

I'd reply and point out the flaw in his logic (he's got scientific method and...

Also look at the data connections in your package. They should be using Windows authentication, not SQL.

Dimbulbz (5/27/2015)

---

Huh, I tried running the upgrade(Express to Full) from the install disk like he said in the article, and I got the message that "there is no upgrade path...

I would seriously consider warning those contractors that you're getting ready to execute sp_drop_contractor. :w00t:

FYI, I only asked this question to show the OP why the missing record was excluded,...

JoshDBGuy (5/26/2015)

---

Did that, there...

Next time, before processing, check the status of the cubes and when they were last processed. That may shed some light on your problem.

Jeff Moden (5/26/2015)

---

You're just asking for a world of hurt in the...