This is similar to Cadavre's but aggregates within the APPLY:

Select

t1.id1, [description] = x.description1,

t1.id2, [description] = x.description2,

t1.id3, [description] = x.description3,

t1.id4, [description] = x.description4

From Table1 t1

CROSS APPLY (

SELECT

Description1 = MAX(d.Description1),

Description2...

Gazareth (7/25/2012)

---

Phil Parkin (7/25/2012)

---

ChrisM@Work (7/25/2012)

---

This looks very much like a homework question, in which case Anthony's reply is a good place to start.

Don't forget that TOP is meaningless without...

Phil Parkin (7/25/2012)

---

ChrisM@Work (7/25/2012)

---

This looks very much like a homework question, in which case Anthony's reply is a good place to start.

Don't forget that TOP is meaningless without ORDER...

Jeff Moden (7/22/2012)

---

ChrisM@home (7/22/2012)

---

Without an ORDER BY, TOP is meaningless:

SELECT

t1.col1,

col2 = ISNULL(t1.col2, x.col2)

FROM @T t1

OUTER APPLY (

SELECT TOP 1

t2.col2

FROM @T t2

WHERE t2.col1 > t1.col1

AND t2.col2...

beeramgopi (7/25/2012)

---

DECLARE @CumCredit TABLE

(RowId INT, CustomerId INT, TransId INT, Pts INT)

INSERT INTO @CumCredit (Rowid, CustomerID, TransId, pts)

select 1,123,121,10

union

select 2,123,131,20

union

select 3,123,141,15

select * from @CumCredit

select a.*, (select sum(Pts) from @CumCredit where...

krishna.netblogs (7/24/2012)

---

Hi All,

I have a table Tbl1 with the below properties

having 200 lakhs records.

30 Columns

6 columns are configured with Non-Unique,Non-Clustered Index

1 Column with Clustered Index

I have to execute the below...

Best way is not to use dynamic SQL. Are you sure you need to?

SELECT

IncidentIdNbr,...

cascaded (CROSS) APPLY is ideal for this:

DROP TABLE #Sample

CREATE TABLE #Sample (username VARCHAR(20), gender CHAR(1), agegroup VARCHAR(3), profiles VARCHAR(20), profile_new VARCHAR(20))

INSERT INTO #Sample

SELECT username = 'Edward', gender = 'm', agegroup...

XMLSQLNinja (7/23/2012)

---

ChrisM@home (7/20/2012)

---

Recursion is the third fastest; CLR > "Quirky Update" > rCTE > cursor >...

6-(hydroxymethyl)oxane-2,3,4,5-tetrol

You guys have been having way too much fun while I've been away.

The plan for this query (once the missing ORDER BY is in place)

lokeshvij (7/22/2012)

---

Here it is (there can...

Better duck now, Joe.

Not all experienced SQL Server developers appreciate the importance of code performance - as a relative newcomer it may have passed you by, even after lurking around here for a...

How does DR_Premier_PO_O fit into all this? There are various references to it in your script but none of them make much sense. If it's...

If you chose a looping method over 5 faster, simpler set-based...