Sean - many thanks for your perseverance on this. I've found a solution by revisiting the logic but really appreciate your patience and responses.:-)

The process is used to collate contract information for our customers. Each customer will have a savings start date per contract if the contract is applicable to them. The savings...

Thanks for your patience Sean, here goes..

I'm trying to calculate the difference between the start of the financial year (in this case 1st April 2013) and the savings start date...

Noted for next time Sean!:w00t:

The output from the sample data gives you the number of months between date x and date y and runs perfectly fine on it's own. However,...

Thanks for your responses and apologies for not getting back sooner.

@sean Lange - Thanks for introducing those aliases as it is far easier to read! The results from...

No, removing the ISNULL returns integers only

Bru/Lynn

Thank you for posting the help on this query - I have found it very useful as I have just performed the same operation with 10m rows and 35 columns....