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

Koen Verbeeck (6/18/2014)

BWFC (6/18/2014)

Koen Verbeeck (6/18/2014)

BWFC (6/18/2014)

This explicitly rules out that the databases are...

Koen Verbeeck (6/18/2014)

BWFC (6/18/2014)

This explicitly rules out that the databases are in the cloud,...

This explicitly rules out that the databases are in the cloud, the answer to...

rhythmk (6/17/2014)

Here...

How is the order you want being decided? They appear essentially random to me.

What Koen said.

Yesterday I was wondering why we had some call data with a 1753 date on it. I thought it was our problem until I looked up that.

Edited...

If you read this article it should point you in the right direction. It will be almost impossible to write the exact query you need from the...