Many ways of doing this, here are two quick examples. BTW, thanks for the nice DDL/sample.

😎

Slightly long winded pre 2012.

;WITH LIC_TYPE AS

(

SELECT

TL.ID

,ROW_NUMBER...

I see steadily increasing demand for SQL Server professionals, it is the de facto database platform for small and medium enterprises, and one of M$ best money buckets.

😎

Further on Jason's advice

😎

USE tempdb;

GO

create table dbo.names (Place varchar(50));

insert into dbo.names ( Place) values ('(1)');

insert into dbo.names ( Place) values ('(100)');

insert into dbo.names ( Place) values ('(200)');

SELECT

...

Lynn Pettis (6/18/2014)

---

Grant Fritchey (6/18/2014)

---

SQLRNNR (6/18/2014)

---

jasona.work (6/18/2014)

---

GilaMonster (6/17/2014)

---

Gotta love a review system where an above-average rating requires "Leaves only when work is done and stays to assist others"

"No pressure to...

raju.venkatsv (6/18/2014)

---

Thank you for your quick reply.

request you to provide some hints or some information , using which i can update my trigger to meet business requirement.z

requesting you for...

mickyT (6/16/2014)

---

One to make you smile if you have 2012:-)

DECLARE @smiley varchar(20) = 'Dont Worry Be Happy';

WITH Params AS (

SELECT MAX(CASE WHEN ItemNumber = 1 THEN Val END) OFFSET,

MAX(CASE WHEN...

trikha.ishan (6/18/2014)

---

Hi,

I tried to update the .dtsx file using notepad in development server and that change is in Script Component but when I ran the package that change didn't reflected...

Thanks!

😎

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