Hi there,

This looks messy so I will try and find a better way to do it.

SELECT

CONVERT(DATETIME,(RIGHT('23/07/2007'

Have you tried using

TOP

or

PERENT

Thanks

Chris

Hi,

Sorry please ignore my first explination as I didn't see your order by clause!

I am also now asking myself why your way isn't the correct way to do it.

I have...

Hi Edmund,

Sorry that explination was incorrect please ignore my last post!

Thanks

Chris

🙂

Lets say for example the data in our tables was stored in an order on disk that was not what we expected it to .

for example the 1st records was...

HI Edmund,

Your method does not guarantee that you will get the status with the maxdate.

Thanks

Chris

Hi There,

What I mean is that I can actually run a select on the view.

I think if you want to see it under the Database you need to grant the...

Hi there,

As far as I remember case statements are the only way in SQL2000

There a re few ways to do this.

SELECT

CONVERT(VARCHAR(13),GETDATE(),11)

HI Scott,

Is what I used to recreate what you are trying to do.

You'll see where you need to Add any other Coloumns such as [Item D] etc

CREATE TABLE SubQuery

Are you using SQL 2005?

If so try using a pivot

If you not sure how to do that give me a shout.

Thanks

Chris

Hi there,

You shouldn't need to grant perms to the table.

Here is the code I ran and it worked 100%

CREATE

TABLE Courses

(ID...

Hi there,

What format do you want?

thanks

Chris