You need to put the DESC keyword on both columns in your ORDER BY clause.

i.e. select * from table order by col1 desc, col2 desc

DavidBurrows,

What would you do if you need more then 2 decimal places.

A simple way to do the right justification would be to concatenate the SPACE and CONVERT(varchar, ). For...

Try:

SELECT SUBSTRING(<existing column>, CHARINDEX(' ', <existing column>, 1) + 1, 1) +

CASE WHEN CHARINDEX(' ', <existing column>, CHARINDEX(' ', <existing column>, 1) + 1) > 0 THEN SUBSTRING(<existing column>,...

Jeremy

I like your solution. I have had a similiar situation but I did not want to use dynamic sql to solve it. So, I ended up using a...

To change the values in the pass-through query you will have to use a little bit of VBA. You will need to set up a QueryDef object and set...

For the company that I work for, it is part of the SQL Server Standards that all tables will have a Primary Key and will use Foreign Keys where required.

...

Try moving the ',' into the ISNULL function.

SELECT Col1 + ISNULL(', ' + Col2, '')

This way the comma will show up only when you have a non null value in...

I am curious about inserting into a table.

Is it better practice to do a 'INSERT INTO <Table Name> SELECT <fields> FROM etc..'

instead of 'SELECT <fields> INTO <Table Name> FROM etc...'

...

By using the OR clause, you will get both. The OR clause returns all records that match either criteria (ie.. The course is active or the course name starts...

couple of my backups have had troubles because of our network being to busy. I put a 15 minute delay on the re-try and to re-try 5 times. ...

What I have found that works the best is to keep it as simple as possible. The next person that does our job may not understand what we have...

What about setting up the backup job to run every hour starting at midnight and running to whatever time.

Then have the job check your BackupDatabases table for which databases need...

Please ignore above post. I just re-read the QOD and saw that I missed the reference to the Backup instead of the file size of the log.

I have the same question as Kelseyv. I went to Books Online to check the answer and this is what I found:

When FULL is specified, database backups and transaction...