Back to PIVOT but from a different angle

 I read up on SSRS matrixes and experimented with my query only to find that I needed to created calculated fields off of dynamic fields that don't exist at runtime. So disappointed, but undeterred. I looked at what I could do for advanced uses of sp_executesql and after quite some time researching, I finally settled on creating a table valued function that houses my PIVOT operator query. Hopefully that will get me where I need to be with dynamic columns that change year to year.

Between my meetings and deployments and research, I snuck in a quick bike ride, then a slow walk, as an old injury with my toe left me with a slowly growing damaged toenail that, while it's mostly grown out and new nailbed has appeared, the damaged bit finally fell off, so I wanted to see what kind of pain I would get from going for a walk. The answer seems to be "slight" and "I should probably be careful for a few days and not run until Friday." Guess I'll just tape up my toe carefully and have another walk tomorrow.

Comments

Popular posts from this blog

Board games and near the end of the gym challenge

December Challenge has ended!

I'm a hurricane!