But isn't a semi colon required I the CTE is in a stored procedure?

*smile* an "oooops" button!  That made me smile!

Unfortunately not.  That is why adding fields to the bigger databases causes havoc for those trying to meet deadlines on that workspace.

I am...

Unfortunately this application doesn't work quite that simply.  "Relativity" is an eDiscovery platform that allows users in the course of their work to add and remove fields that they believe...

Hi Jo,

Many thanks for the answer.  Had I considered DDL actions and DML I should have come to the same conclusion.

Ho-hum.....then I need another solution.

Regards,

Kevin

Hi all,

many thanks for all the hints and tips but I have gone for creating the report in SSRS and then importing it as a default report into...

I have been testing SQL Server on Ubuntu and have to say the experience is a very comfortable one.  It is true that the amount of features available at the...

Hi Folks,

thanks for your help and sorry I haven't answered sooner.  I am still fighting to make this work and have decided to leave it unresolved for the...

I am hoping this isn't too obvious but are you using a TNSNAMES.ORA?  If so are there any errors in the file that could cause connection errors?

I have...

Hi Perry, thanks for the answer.

Sounds like an elegant solution......now to test!

Is this an Oracle question, SQL Server question a mix of both?  Looking at the question and trying to understand it I am imagining some data resides on Oracle and...

My advice?  Pick up a book in your hand, flick through it looking at themes you are already somewhat familiar with and decide for yourself whether the way it is...