Read this article[/url] and after you're read it, fix your post so that it's answerable.

Self-joins with aggregates. YUCK.

How about something really simple... maybe like this?

SELECT PatientID

, SessionID

, SessionTime

, LAG([SessionTime]) OVER (PARTITION BY PatientID ORDER BY SessionTime) AS PrevSession

FROM

(SELECT 1 AS PatientID, 1 AS SessionID,...

Well, you can't turn columns into rows from that... there's nothing to pivot on.

You might want to read this article[/url].

Can you please explain the logic of how to get the result you're looking for? Maybe I'm slow, but that part baffles me. Maybe there's something you understand about the...

Are there tables with the data in it somewhere that you could share? From your sample data, it's not entirely clear which columns belong in which logical group (table).

1234...

Short answer is that it's a cross join of the first 3 columns (all possible combinations) and then outer join back to the original table to pick up the nulls...

Did you try LEAD()?

Either you have something wrong in your data or T2 is irrelevant to the question.

Here's my solution with the sample data included. Note that the second table you provide is...

Your question forced me to look up the definition of the grain of a table... good thing to do.

Identifying the level of detail

The level of detail that is available in...

Can't vouch for any of this, but here's a discussion very similar to what you're trying to do.

I think I understand what's up with this... D3 apparently consumes JSON data. check out Mike Bostock's site... If you look at the bottom of the page,...

Is there any kind of consistency in the Excel files? Do the contents of Sheet1 always go to a specific table? If the sheet sequence and column sequences are consisent,...

If you have any say in the structure of the database, stay away from a design where you have dates/information for column names. Been there, done that. It was an...

Sounds like homework. So I'm not going to give you a direct answer, because then you wouldn't learn anything. And this forum isn't an answer machine...

If you're...

Did this ever work in Access? If so, I would look at the RowSource properties of the various forms involved, so you know what's coming from where. Once you...