Interesting question, looking forward to the replies!

I personally would probably use a loop for this. The difference is that I'd loop over the number of concatenations needed, not the number...

TomThomson (8/2/2016)

---

patrickmcginnis59 10839 (8/2/2016)

---

Iulian -207023 (8/2/2016)

---

TomThomson (8/2/2016)

---

Nice question.

It indicates yet another piece of really sloppy human interface design on Microsoft's part. if Foreign Keys on temprorary tables are...

Iulian -207023 (8/2/2016)

---

TomThomson (8/2/2016)

---

Nice question.

It indicates yet another piece of really sloppy human interface design on Microsoft's part. if Foreign Keys on temprorary tables are not enforced, allowing...

Doctor Who 2 (7/24/2016)

---

I finally got my SQL Server database uploaded into Azure SQL! I posted a blog post about it. Rather than repeat what I did I'll just give...

TomThomson (8/2/2016)

---

Nice question.

It indicates yet another piece of really sloppy human interface design on Microsoft's part. if Foreign Keys on temprorary tables are not enforced, allowing them to...

robert.sterbal 56890 (8/1/2016)

---

Fortunately Marissa Mayer, the proponent of everyone in the office at Yahoo decided to collect her $50 million dollars, close her think tank, and stop promoting the benefits...

Check this article out, pretty much gives you the run down. Direction matters!

http://sqlblog.com/blogs/linchi_shea/archive/2010/12/01/linked-server-and-performance-impact-direction-matters.aspx

GSquared (7/28/2016)

---

That is weird.

I tried a few things like having the ON condition include both tables, and it still worked.

Always updated from the header table, not the detail table, so...

where's the set oriented version? 😉

awesome!

kat35601 (7/25/2016)

---

I tried this but it did not work. the column does change to x2013 but the data rows for that column become 2013 etc

select

week_,2013 as x2013,2014 as...

Brian J. Parker (7/18/2016)

---

Sorry to...

Igor Micev (7/12/2016)

---

patrickmcginnis59 10839 (7/12/2016)

---

An ORDER BY clause can be used explicitly in the end as well. In that case the COUNT is not deterministic. See Deterministic and Nondeterministic Functions...

but the...

Eric M Russell (7/6/2016)

---

For key value pairs, this is typically what you want. If name exists (@@rowcount = 1), then it's value is updated. If name doesn't exist (@@rowcount =...