Ok, I'm going to mark this as answered but, I believe the issue lies in user error 🙂

Original Method I was using to modify SQL Server Network Name:

1. Failover Cluster...

I am in the process of moving production databases over to a NetApp 2040 SAN and I can commiserate with "death by documentation". I've spent weeks rummaging around on...

Thank you both. Paul, your blog has been most helpful and I threw the kitchen sink at this, so to speak. I began to suspect exactly what you...

Thank you, Paul and everyone for your help. I can ensure that the shift start times are sorted properly so this will work for my needs.

bitbucket,

Your solution is not correct as far as what I'm attempting to accomplish.

Shift_Type A and B denote the two different systems an employee can be logged into (which can overlap,...

Sorry for any confusion. What I am inquiring about is a subset of a larger process and my example data is simplified. I need to calculate hours worked...

Thanks for that. I actually came across a post on an Oracle forum that detailed what you mention above. I got up, took a walk, wished I could...

Thanks Johnathan. Your points mirror many of my concerns from reading about SQL server and SAN implementations. They also want to put pretty much everything requiring storage inside...

As far as the dynamic SQL goes it was written by QA. I haven't been here long and was asked to look into the issue. It is an...