I have seen this occur once in a while. Others may frown on this but based on this statement from your original post, KILL 127 WITH STATUSONLY (it said...

Short term memory sucks, but unless you...

cunningham (5/29/2015)

---

One for Grant (or anyone that knows on Grant's behalf), I hope you don't mind me asking but what is your avatar picture? My mind keeps telling me it's...

Those of you on the view thread, Don't expect much and be sure to have a silver spoon.

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

Eirikur Eiriksson (5/29/2015)

---

Lynn Pettis (5/29/2015)

---

We know that the Crystal Ball shows nothing but the clouds, but where is the silver spoon?

< rant >

I am still amazed at how many people...

Fix the data.

Using the data setup from Eirikur and the data I added, the following works. Not knowing the state of your data, however, I can't promise anything.

SELECT

...

Further testing, only 10005 causes an error. Check to see if any data is missing the comma (,).

I added the following values to Eirikur's setup and I get failures now. Definitely need to check your data.

,(10003,null)

,(10004,', fe70::28d9:l69a:5bbd:ab2f')

,(10005,'132.235.219.113')

It isn't nulls. I used the setup provided by Eirikur above and added a null...

Check your data to be sure that there are no null values or values with an...

SELECT

sre.*,

ca1.IP,

ca2.MAC

FROM

...

We know that the Crystal Ball shows nothing but the clouds, but where is the silver spoon?

< rant >

I am still amazed at how many people have to have things...

TJT (5/29/2015)

---

I am trying to get this to work without sample data and I get IP_ADDR is not recognized. I really appreciated everyone's patience on this.

SET NOCOUNT ON;

WITH SAMPLE_DATA(IP_ADDR)...