You guys are great, thanks very much for your assistance, its working, created the view and all is working.

Thanks very much have a great day

I have the sample you gave me and its working, thats fine. How will i create a view now in SQL?

It is the business rule that after a restructure has been done, then a new version is created with the structured amount which will be taken into consideration.

Thanks Guys for your help, this one worked (SELECT 1 / NULLIF( ISNULL(@thirddatediff,1) - ISNULL(@seconddatediff,1), 0);)

thanks very much, will try and let you know the outcome