tskelley (8/1/2016)
Yes, and thank for your pointing out the sarcasm. I have removed it from my reply. I was a little frustrated on this one, and found the comments were on the periphery of the issue.And yes, I continued to battle this over the weekend and found out there is an issue with some kind of "hidden" character(s) causing the view not to format correctly for older versions of SQL (2008R2 and below were affected). I had never run into an issue like this before, and the only difference in code was the ISNULL without and then with the CHAR(10) being included, but as I mentioned this was not the issue.
Thank you all for your help,
Tom
Tom, thank you for posting that you had solved your problem and explaining what the issue turned out to be. It's good to have that for closure. We've all been through times when we were supremely frustrated over problem issues and the frustration is compounded when its difficult to supply the details that others are asking for. But please understand that everyone answering questions here is doing so on their own time out of the goodness of their hearts. No one (except Steve) is getting paid to do it. No one has a service-level agreement with the people posting questions, but they really do want to help. We're all glad you found your answer. Best of luck in the future.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills