Check out DATEADD() in BOL.

You're welcome, thanks for the generous feedback 🙂

L' Eomot Inversé (7/26/2012)

---

ChrisM@Work (7/26/2012)

---

Tom, carbohydrate chemistry is a massive and important field of study which we barely touched on when I did my bichemistry degree in Aberdeen in the...

Ah I see, sorry my mistake. Try this:

SELECT l.ID, l.Dateref, n.ID, n.Dateref

FROM...

GigiMi (7/27/2012)

---

For example, if I pass the date '2012-07-02 10:00:00'

(more recent than any other record) I'd like to obtain something like this:

PreviousID - PreviousDateRef - NetxID - NextDateRef

25...

GigiMi (7/27/2012)

---

...I need to obtain values also for the next record in the case it does not exist (for example if i pass a datetime more recent than every record...

Here's a couple of ways:

DROP TABLE #Sample

CREATE TABLE #Sample (ID int, DateRef datetime, GroupID int)

INSERT INTO #Sample (ID, DateRef, GroupID)

SELECT 17, '2012-06-20 10:00:00.000', 463 UNION ALL

SELECT 21, '2012-06-22 12:00:00.000',...

Heya Pauliepoos, haven't seen you posting for ages!

SQL Kiwi (7/27/2012)

---

ChrisM@Work (7/27/2012)

---

I'm still uncomfortable with "in order to handle our longest string (500,000 characters)". In all the time I've been working,...

You've probably cracked this now Anthony, with Lynn's code.

You could do this with a QU on the output but you'd have a new column with an incrementing string until...

Lynn, just out of curiosity - because I don't know and "a developer should always know" - do you...

Jeff Moden (7/26/2012)

---

I know I enjoyed it. Gave me a chance to try out my new 4 band porkchop...

How many rows are you working with? It would be...

Very interesting. Thanks, Wayne.

CROSSTAB and FOR XML PATH would be the most popular around here, there are loads of examples on ssc. FWIW there's a similar thread here.

L' Eomot Inversé (7/23/2012)

---

Jason's C6H12O6 is a nasty ambiguous formula. ChrisW's thing is less ambiguous (but still ambiguous).

There's a nasty ambiguous word for it: hexose; but it's...