GilaMonster (10/12/2010)

---

After a meeting this morning there are several things that I would love to rant about at length. However it might get ugly. Hence I will restrain myself to...

Paul White NZ (10/12/2010)

---

Ah I see that thread is fully doomed now - Chris Morris has...

I'm going...

Continuously? To the same person? Well done Ray. Happy Anniversary!

Check again - looks like it's failing on business rather than email.

Grant Fritchey (10/12/2010)

---

Brandie Tarvin (10/12/2010)

---

Paul White NZ (10/11/2010)

---

A...

See Cross Tabs and Pivots, Part 1 – Converting Rows to Columns[/url]

and Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs[/url].

george sibbald (10/11/2010)

---

WayneS (10/10/2010)

---

Hey gang... not definite yet, but my wife is talking about letting me spend the $ to go to PASS. 😀

Any suggestions on good, inexpensive, close places...

TheSQLGuru (10/11/2010)

---

We SOOOOOOO need full Windowing Function support in SQL Server. And yes, performance on this type of query will currently be exceptionally poor and approaching non-functional on increasingly...

ta.bu.shi.da.yu (10/11/2010)

---

If I read this correctly, you just implemented the LAG(...) Over(...) analytic function.

However, I'm interested... if you do this on a large dataset, what does the execution plan...

Brandie Tarvin (10/8/2010)

---

Chris Morris-439714 (10/8/2010)

---

Behaviour,...

CirquedeSQLeil (10/8/2010)

---

So now you have...

Grant Fritchey (10/8/2010)

---

Jeff Moden (10/8/2010)

---

The Dixie Flatline (10/7/2010)

---

I just had an idea for an epic summer movie. It involves an intrepid group of DBA's and SQL...

SELECT

COALESCE (dZ_Field1 + CHAR(13) + CHAR(10), '') +

COALESCE (dZ_Field2_A + CHAR(13) + CHAR(10), '') +

COALESCE (dZ_Field3_A + CHAR(13) + CHAR(10), '') +

COALESCE (dZ_Field3_A + CHAR(13) +...

Or this, which works on the raw data i.e. before the first aggregation step:

SELECT

d.kunnr,

d.zterm,

d.cnt

FROM (

SELECT

g.kunnr,

g.zterm,

g.cnt,

rn = ROW_NUMBER() OVER (PARTITION BY kunnr ORDER BY zterm, cnt DESC)

FROM (

SELECT

kunnr,

zterm,

cnt...