If Einstein would have had SQL Server, it would have been so much easier:-D

😎

USE tempdb;

GO

;WITH SQL_VISDOM AS

(

SELECT

ROW_NUMBER() OVER...

That was a very quick upgrade:-P

Any sample data?

😎

No problem there, only excludes the 2012/14 window functions. Could you provide some sample data + table structure?

😎

sparikh (6/17/2014)

---

Hello All,

I am new to OLAP Reporting.

After creating cube i can also view it in BI Browser is there any other way to run it or how do...

Quick questions: are you on 2008 platform? Can you provide some sample data?

😎

Two solutions, first one for 2005 and later, the second 2012 and later. The difference is that the first one uses self-joining which makes it less efficient. For very large...

pietlinden (6/17/2014)

---

I think I just very carefully solved this using a 2012 solution... figured I would post it for people to tear apart...

the ROWS PRECEDING window function is new in...

wolfkillj (6/17/2014)

---

I found a place I can take Joe Celko's bait without bursting an aneurysm.

Joe's challenge: Implement Conway's Game of Life in SQL.

My solution on my blog.

The Schelling model...

cbrammer1219 (6/17/2014)

---

Just curious could I create a lookup table with all the extension in it and then insert that into the CallTrace table where the extension and do the same...

Sean Lange (6/17/2014)

---

Eirikur Eiriksson (6/17/2014)

---

Grant Fritchey (6/17/2014)

---

SQLRNNR (6/17/2014)

---

Eirikur Eiriksson (6/17/2014)

---

Sean Lange (6/17/2014)

---

SQLRNNR (6/17/2014)

---

Did you notice that the "Active Threads" on your inner window was missing?

My active threads has been missing...

Sean Lange (6/17/2014)

---

Eirikur Eiriksson (6/17/2014)

---

Grant Fritchey (6/17/2014)

---

SQLRNNR (6/17/2014)

---

Eirikur Eiriksson (6/17/2014)

---

Sean Lange (6/17/2014)

---

SQLRNNR (6/17/2014)

---

Did you notice that the "Active Threads" on your inner window was missing?

My active threads has been missing...

GilaMonster (6/17/2014)

---

Eirikur Eiriksson (6/17/2014)

---

GilaMonster (6/17/2014)

---

No.

There is no process in SQL that you can run or kill that...

Grant Fritchey (6/17/2014)

---

SQLRNNR (6/17/2014)

---

Eirikur Eiriksson (6/17/2014)

---

Sean Lange (6/17/2014)

---

SQLRNNR (6/17/2014)

---

Did you notice that the "Active Threads" on your inner window was missing?

My active threads has been missing most of the day....

dirk.dromgoole (6/17/2014)

---

The issue was that a copy of the program that was being executed was somehow locked into cache on the server. After the program was unlocked it picked...

SQLRNNR (6/17/2014)

---

Eirikur Eiriksson (6/17/2014)

---

Sean Lange (6/17/2014)

---

SQLRNNR (6/17/2014)

---

Did you notice that the "Active Threads" on your inner window was missing?

My active threads has been missing most of the day. For...