Do you mind if I borrow that?

Method

I got one of Andy's right!!!!!!!

TomThomson (6/18/2014)

---

BWFC (6/18/2014)

---

I disagree there. It doesn't say that all on site databases are 2012, it says that uses 2012. That doesn't preclude there being...

SELECT distinct

q.Description

,SUM(q.Amount) OVER (PARTITION BY q.Description)

FROM #Question q

It might be worth you trying to create some sample data that's closer to what you actually have. You can do...

And another thing!!!

The company I work for is constantly employing,...

mattech06 (6/18/2014)

---

Actually guys, the old classic, it worked on that specific example but not on the full data set.

So a better example would be using a table with ..

CREATE TABLE...

You're welcome.

If you have read of this article [/url] then it'll be much quicker getting an answer in future. It'll save people having to make assumptions and it'll...

You can use one CTE after another, like so:

CREATE TABLE #Question ([Description] VARCHAR(15), [Amount] INT)

INSERT INTO#Question

SELECT 'Bob', 10 UNION ALL

SELECT 'Tim',20 UNION ALL

SELECT 'Jim',30

;

WITH cteTest AS

(

SELECT * FROM...

Rhythmk's solution does exactly what you want or the alteration to my solution below will do the same, although much less elegantly.

SELECT

q.[Description]

,SUM(s.totSum)

FROM #Question q

CROSS APPLY

(

...

I see, so you want whatever is the first description value to be the description that is displayed.

How is the ordering done? Is it done on the value of the...

John Mitchell-245523 (6/18/2014)

---

Precisely. All on-site databases are 2012, meaning 2000 can't be the answer. And since...

CREATE TABLE #Question ([Description] VARCHAR(15), [Amount] INT)

INSERT INTO#Question

SELECT 'Bob', 10 UNION ALL

SELECT 'Tim',20 UNION ALL

SELECT 'Jim',30

SELECT

[desc] =q.[Description]

,amt = SUM(s.totSum)

FROM #Question q

CROSS APPLY

(

SELECT

totSum...

GilaMonster (6/18/2014)

---

Except...

Toreador (6/18/2014)

---

You are working for a company that has uses SQL 2012 for their on site databases. A fellow DBA is trying to do a quick check on a database...