Jinxsee (9/27/2012)

---

select

VALUE, YEAR, MONTH, MARK from

(select VALUE, YEAR, MONTH, MARK, ROW_NUMBER() OVER(PARTITION BY VALUE ORDER by...

;WITH CTE AS (

SELECT

Name,

[Month],

[Year],

Mark,

rn = ROW_NUMBER() OVER(PARTITION BY Name ORDER BY <<Something>>)

FROM tblStudent

)

SELECT

Name,

[Month],

[Year],

Mark

FROM CTE

WHERE rn = 1

Nope! Miles off. Did you read the spec?

Craig,...

Any time. There's a great set of articles by Paul White covering APPLY, links in...

Post the whole query, mate...

(CROSS) APPLY is ideal for this:

CROSS APPLY (

SELECT DueStatus =

case

When NextReviewDate < getDate() then 'Over Due'

When NextReviewDate >= getDate() And NextReviewDate < getDate() + 30 then 'Due In...

antonio.estima 4150 (9/26/2012)

---

...In SQL Server 2K or 2K5 the WHERE clause where SUBSTRING(nomeint,1,1) = 'P' is run first in the subquery and then it does the join. However, in SQL...

tim_harkin (9/26/2012)

---

Not the most efficient solution....

DECLARE @currentTime DATETIME

SET @currentTime = GETDATE()

SELECT CAST(DATEPART(year,@currentTime) AS CHAR(4))

+ CASE WHEN (DATEPART(month,@currentTime)) > 10 then (CAST(DATEPART(month,@currentTime) AS CHAR(2)))

ELSE '0' + CAST(DATEPART(month,@currentTime) AS CHAR(1))...

This doesn't make sense.

SUBSTRING (nomeint,...

Charmer (9/26/2012)

---

Charmer (9/26/2012)

---

Hi Friends,

I have a doubt regarding joining two tables, so i came here to...

PiMané (9/20/2012)

---

Hi,

Is it possible to have a column on table A that references table B or table C depending on another column on table A?

For example:

EntityAddresses (EntityAddressId, EntityType, EntityID, Address)

Customers...

saidapurs (9/26/2012)

---

Hi All,

Using below conversion i am getting date only like 20120926 but my requirement is 201209261015 like hour & time

convert(nvarchar(50),(GetDate()),112))

Please help...

Abu Dina (9/26/2012)

---

Your solution works great but unfortunately the rCTE isn't scaling well enough. With 150000 rows it takes 7 seconds to process. With 160000 records it takes 17 seconds....

Lynn Pettis (9/25/2012)

---

Here is my code, reformatted the way I like to it.

with rCTE as (

select

t1.retained,

t1.dropped,

t1.retained as TopLevel

from

...