Great! Thanks for the feedback

Use group by and some summary function. e.g.

SELECT Room,

max(CASE Period WHEN 1 THEN Description ELSE NULL END) AS 'Period 1',

max(CASE Period WHEN 2 THEN Description ELSE NULL END) AS 'Period...

I should mention something about the pros and cons of the 2 methods we've got here (the one I gave, and the one David gave). The method I gave should...

You're too kind, Sergiy.

The difference is just that column x is included. I know it's not difficult - I was just trying to explain (to myself and others) why A had...

You shouldn't need to reinvent the wheel. Use something like this (and modifiy slightly, if necessary)...

http://www.sqlteam.com/item.asp?ItemID=2955

Hi Chris,

The calculations thing shouldn't throw you off - most of the examples are not really about calculations, that's probably just the max keyword trick you're seeing.

Here's how you can...

I guess it's Nigel you should be thanking!

It looks like you're asking for a pivot/crosstab query. You can search this site for that to find several related questions.

I find this (or something based on it) to be handy for...

If you use the datetime data type (and you should!), the stored format is irrelevant. The format you use to query those fields is a different matter.

This answers your question...

Here's one technique you can use...

If this isn't what you want, please explain some more.

--data

if object_id('tempdb.dbo.#t') is not null...

http://mindsdoor.net/SQLTriggers/AuditTrailTrigger.html

http://mindsdoor.net/SQLTriggers/Triggers_2_Creating_Audit_Trails.html

Hi all,

What a confusing question!

If I've managed to understand it correctly, here's my suggestion. I've changed the data to (hopefully) make it a...

I don't know, you try to teach a man to fish, and someone hands him their catch...

To solve this kind of problem, I would recommend the following approach:

1. Simplify it until you find something which works

2. Build it up bit by bit until it breaks

3. Figure a...

Maybe this will help...

http://wiki.ittoolbox.com/index.php/Code:Get_Records_from_ANY_table_in_a_Database_Matching_Specified_Value