Is there a way to get the Like/Share/Report buttons on the same line as the Reply/Multiquote buttons?

I do like the preview down at the bottom.

Drew

vpolasa (1/11/2017)

---

Please correct me if I'm wrong. Do I need to use RAW mode when using ELEMENTS XSINIL? In this case a new subelement is created. I might not need...

It's because you're converting your XML to VARCHAR(MAX), just leave it as XML and you shouldn't have these problems. The FOR XML directive treats text that looks like XML...

JJMEIJER (1/10/2017)

---

My suggestion would be to use a PIVOT clause:

WITH cteSports AS (

SELECT * ,sn = ROW_NUMBER() OVER (PARTITION BY name ORDER BY sport)

FROM #example

)

SELECT name,...

It helps if you specify what the error is when you get an error. I ran your code and did not receive an error. My best guess is...

MMartin1 (1/10/2017)

---

drew.allen (1/10/2017)

---

MMartin1 (1/9/2017)

---

How about

SELECT CASE WHEN NULL IS NOT NULL THEN NOT NULL ELSE NULL...

MMartin1 (1/9/2017)

---

How about

?

same...

The problem is that the definition of "duplicate" here is not well defined. Specifically, you want to count times as duplicates if they fall within a specific threshold of...

Reported as spam.

Reported as spam.

CELKO (1/7/2017)

---

The check constraint can be used by the optimizer immediately; it...

You do have a partial CROSS JOIN somewhere. Looking at the query plan, the hash match join has inputs with 297K and 907K rows, but the output is 129,682K...

I'm about to leave on vacation, so I don't have time to do a thorough write-up, but the general approach is to use a tally table to get a row...

CELKO (1/5/2017)

---

I would make the argument that the list of...

I've looked at this, and I have lots of questions. Specifically, it looks like a_site_id should be part of the primary key, but it is not used in any...