asked on

sql 2005 pivot data

id date time
id1 11/8/2013 900
id1 11/8/2013 1000
id2 11/8/2013 910
id2 11/8/2013 1010

if I have data like the above and I want to rearrange it like this:
id date time1 time2
id1 11/8/2013 900 1000
id2 11/8/2013 910 1010

What is the best sql to do that? Acceptable answer must be for sql server 2005 and sql only.

Brendt Hess

There are a lot of assumptions that need to be made to answer this question. And this sort of looks like instructional work, not real world work. This would not need to be pivot data at all, and as structured really is not suited to be pivot data.

HINT: Look at using MIN, MAX, and GROUP BY for your query.