Thanks for your reply

Really helpful

Great ! 

I will give it a try

thanks

Apologies didnt see your post. 

let me take a read and see where I get.

Thank you both for your explanations. 

Tom- I'm going to be honest, I can't get my head around how TRY, CATCH and TRANSACTIONS fully work.

Is there a Lehmans...

thanks for you comprehensive reply.

This should solve my conundrum 

thanks again!

Great stuff! 

thanks guys

For simplicity I wrote 'when the view changes' I understand that it is the data that the view returns that changes. 

So everytime there is a new entry in the...

Before I begin let me apologise for my earlier posts. It seems that I may offended some of the more experienced SQL users. I am now fully aware of how a...

Hi I used 

select* 
into new_table
from old_table 

But received this warning :

Warning: Null value is eliminated by an aggregate or other SET operation.

Is...

Both very comprehensive replies!

thanks again guys 

Much appreciated

Thanks for all the replies I realized that its much easier to edit the select statement that made the view.

Now I have an extension to this problem;

Yeah I realise that is the easier option( and most likely what I will do), however I was merely enquiring if there is a way around this. 

thanks for...

Apologies for the earlier amateur post,

So from the results set that is returned from the CTE's, I want verify those customers against certain conditions.

So if any customer...