Magnetic

Atheist

Spam

Sorry, couldn't resist :Whistling:

Python

Spam

Spam

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

(

...