Hi Steve,

Thanks for the response, and you're absolutely right in the points you made.

The part of the system I'm working on is essentially a "bolt-on" which will be used to...

Hi Guys,

Apologies for the late response - organising a first birthday is hard work!

Firstly, thank you both for your comments. Dennes, that code worked exactly on the example data, however...

Hi Luis,

Thanks for the reply.

I ended up using a dynamic PIVOT statement which gives me a pivot table for the names and day numbers across the top.

Cheers,

Kev.

Hi SSCommitted,

Thanks for your post. Unfortunately, I won't know how many attributes there will be when I'm looking for a stock. Ideally I'd be looking for something like as follows:

StockCode,...

Thanks for the reply Eugene.

I knew it wasn't a simple query...but I think for now, it might be out-of-scope for my current project. Perhaps at a later date, when I...

Firstly, thank you all for your replies...in a word, you guys are pretty awesome at this whole SQL "thing" 😀

I went back to my original design and changed the StartTime...