Hi Gazareth,

Thanks for the suggestion, unfortunately it doesn't work, but instead produces the error below.

Kind Regards,

David

Hi jonidotcodotuk,

Your generous advice has helped to set me on the right track. Thank you.

Kind Regards,

David

Thanks for the very helpful responses.

Hi All,

Thank you very much for your input. I am actually just using getdate() by itself now, without any cast or convert. My error was of the 'human' type, I...

This code works a charm! Thank you 🙂

I am using the solution provided by 'Roland C'. 🙂

Thanks everyone for your time, and wonderful responses, I have learned a great deal, and am now getting the results I desired.

Hi,

The 'ia' (which I believe stands for Itanium Architecture) also threw me; so I decided to post a screen capture of the installation folder on my computer -

Hopefully this offers...

Definitely Enterprise Edition - I have a database running with several thousand records, and am using Management Studio to manage, and query the data.

Thanks everyone, I have installed the software, and everything is running smoothly.

Yes, definitely the Enterprise Edition (x64)! I am a part time student and got my hands on the EE through Microsoft DreamSpark. I wanted to make sure that I was...

Hi Everyone,

I managed to install MS SQL Server 2008 R2 Enterprise into Windows 7 by following the steps below -

1). Added my Windows Account to 'Debug Programs'

Start | Run |...

Hi Everyone,

Thank you for your interest in my post; here is the additional information that I have been asked to supply -

Details.txt

Any further assistance will be greatly appreciated.

Kind Regards,

Davo

Hi Greg,

Yes results are as I had hoped, however I needed to change my code quite significantly. The major improvement came through adding and AND clause to two of my...

Yes. I did need to change the partition by and order by clause; however the biggest improvement to my results came by using the AND clause on two of my...