Are there any restrictions on which version of SQL can be used to solve this problem?

I think you will find that return will be adding a <P> tag and shift-return will be adding a <BR> tag into the text, many HTML editors work in this...

Sorry, but unless I generate them, I may have to wait for weeks for get any deadlocks in a profiler trace, we very very rarely have any.

You will find the information in BOL - look at the CREATE TABLE command.

Long Running Queries

Use the SQLProfilerTSQL_Duration template and set a Filter on Duration for greater than equal to 1000 (time in milliseconds).

Deadlocks

Tracing deadlocks via profiler will only show you that they...

Although not as tightly integrated as Visual Studio, we have written a stand alone application which connects to SQL via SQLDMO and scripts all the objects to VSS.  Works very...

If you use "set statistics io on" and run the the query in your example you will see that SQL has to perform 475 logical reads.  This is due to...

If you still have access to the source database, perform a Shrink Database operation on the database before taking another backup.

You could also consider changing the recovery mode to Simple...

If you are looking to return just the items despatched during the last calendar month, try using something like this:

where oh.date_despatched between convert(char, dateadd(mm, -1, dateadd(dd, -(day(getdate()) - 1), getdate())),...

......is there an echo in here?

You state that you are limited in using a self join due to the initial statement being very complex and you dont what to repeat it in order to perform...

My mistake (I was reading your post date....4th of the month), try this instead then:

select replace(right(convert(varchar, getdate(), 6), 6), ' ', '')

As you can see there are many ways to do this, and here is another:

select replace(convert(varchar(6), getdate(), 107), ' ', '')

Thanks all, especially Steve for SO many replies (I think he's trying to get increase his number of posts )

Since starting this thread I...

Thanks all, especially Steve for SO many replies (I think he's trying to get increase his number of posts )

Since starting this thread I...