;WITH CTE AS (

SELECT patient_id, attendance_date,

ROW_NUMBER() OVER (PARTITION BY patient_id ORDER BY attendance_date DESC) AS rn

FROM PS_TestForOnline)

SELECT a.patient_id, a.attendance_date, b.attendance_date

FROM CTE a

LEFT OUTER JOIN CTE b ON a.patient_id = b.patient_id...

I've written the query to represent how I think you've explained your task rather than your expected result-set that you provided.

;WITH CTE AS (

SELECT patient_id, attendance_date,

ROW_NUMBER() OVER (PARTITION BY patient_id...

"Warning: Null value is eliminated by an aggregate or other SET operation"

This is probably caused by having ANSI_WARNINGS on and an aggregate on a column which contains a null value.

e.g.

SET...

This is a presentation layer task and should be dealt with there.

However, you can do it in t-sql like this: -

DECLARE @values AS TABLE (value INT)

INSERT INTO @values

SELECT 11000

UNION ALL...

Ninja's_RGR'us (9/6/2011)

---

Cadavre (9/6/2011)

---

There's not way to turn off the transaction log, but if you're using the batching idea that I proposed above then you could try setting to SIMPLE recovery...

There's not way to turn off the transaction log, but if you're using the batching idea that I proposed above then you could try setting to SIMPLE recovery mode so...

Pagan DBA (9/6/2011)

---

I know Timestamp is deprecated. We are using RowVersion.

Besides the point at this time, don't you think? The deprecation of the "syntax" has nothing to do with my...

It doesn't, just a warning that it's likely...

Timestamp datatype is deprecated.

Best bet is probably to use a CLR, but you could use the ASCII function.

e.g.

DECLARE @input VARCHAR(100), @output VARCHAR(100)

SET @input = 'HTH123³Def'

--Tally table would be better, for testing purposes I've...

How's this?

SELECT b.*

FROM (SELECT question

FROM answers

GROUP BY question

HAVING COUNT(question) > 1)...

Nice one Chris 😉

Told you someone would simplify it Greg

Hmmm, not sure that I understand correctly.

(Sorry if I'm a bit slow replying, got a lovely issue that I'm solving at work)

Currently, the code I've supplied would show the following...

Could you show me the expected output?

drew.georgopulos (8/29/2011)

---

thanks to y'all, i was able to answer my own question...took two days, but i work cheap.

i found the answer by construction;

I graphed the original data in Excel

I added...