Well, I learned more and will need to pivot from my PIVOT, and had a great but difficult run

 I was so pleased to learn and use PIVOT and dynamic SQL for my report last week, but when I put it all together, I found out that it wouldn't work in my RDL. I struggled to figure out why, and after some searching on Google, it seems that when you use dynamic SQL and exec sp_executesql, SSRS can't figure out what the columns are, and gives up. I learned how to use SET FMTONLY OFF but that didn't help, sadly. Apparently, I'll need to figure out a different way to build my PIVOT or use the matrix tablix in SSRS, something I've not done a lot with. A quick usage of it showed me either I don't know how to use it (likely!) or that the query I'm using isn't set up the way I need it to be (also likely!)

I decided to wait for another day for learning more about matrixes in SSRS as it was already 5pm. Guess it's a good time for another SQL test. As I set it up, I heard THUMP THUMP THUMP THUMP. Ahh. My downstairs neighbors must be celebrating the end of their workday with some music. Can I ignore it?

No. They turned it up, and now my chair arms are rattling. I really don't want to go talk to them again. I just want them realize what an appropriate level of noise is. I have a new AC, so I decided to turn my AC down another degree to kick it in, then read in another room. I could still hear the music, so I decided I may as well wash clothes. With moving to the other side of the apartment, the AC going and the washer going, I finally was able to drown out their music. 

Happily, it seemed they only wanted to play it for an hour and a half, so now I have clean clothes, a cooled apartment, and a quiet place again. I'd try for the test again, but I'm meeting with one of my friends (virtually) in about a half hour, and have yet to eat dinner. Hopefully they're done playing music for a while!

In other news, I ran a 5k this morning that ended up being my fastest yet! (Yes, I'm still dreadfully slow.) Around 0.75 miles I thought about turning around at the 1 mile mark. Then I decided I could go a little further, and turn around at the bridge, 1.25 miles in. As I went under the bridge expecting to turn around at the other side, a guy started shouting at me "You got this! Go! Go! You can do it!" as he passed. I thanked him and decided to go all the way to the 1.55 mile mark and turn around there, for my 3.11 full run. Even though I needed to walk most of the third mile, I ended the run with 43:24, my fastest since last November's Hope Through Education 5K when it was 40 degrees. I'm very pleased!

Comments

Post a Comment

Popular posts from this blog

Halloween Party and my costume

Image
This weekend, I attended an awesome Halloween party, and even dressed up as Hermoine Granger. I admit, it was a bit fun to dress up as Hermoine Granger. I took a lot of thought for my costume. I started searching for costumes on August 26th, and found a costume site on September 13th:  https://www.moviescostume.com/harry-potter-gryffindor-uniform-hermione-granger-cosplay-costume-adults-ver.html However, I didn't want to just drop over $100 on a costume I'll likely only wear once. What else can I do? Can I just build the costume from regular clothes? After all, Hermoine mostly wore a school uniform for the first few movies. Certainly I could do that. I set off to build my uniform. I got the skirt from Lands End. The socks , blazer , patch ,  tie  and wand from Amazon. The shirt came from J Jill, but I bought that about ten years ago or so, and the shoes I purchased last year from Belk. I referenced this guide to learn how to tie a Full Windsor Knot, a tie style wit
Read more

Board games and near the end of the gym challenge

Today was another success! Went to the gym after my two cups of coffee, warmed up the rest of the Picadillo for lunch, and finished a few chores. This evening, I was invited to a board game night with a few friends. We played Spinjas and Stuffed Fables. The gym was my last arm/chest routine day until the 31st, where I'll do the full body routine and see where I gained. I'm certain I didn't lose weight - way too many cookies and candies around to snack on, but hopefully I'm stronger. I certainly feel stronger and better, and that is enough to keep going. I'm looking forward to getting a better diet in January by not having sugar for the month, and continuing to go the the gym - just not daily. Stuffed Fables is a really cute game! We played Story 1 where a girl's blanket is stolen from a little girl's bed, and the Stuffed animals characters, Theadora, Stitch, Flops and Lumpy have to travel through the underworld to rescue the blanket and get back to bed b
Read more

Jose and Sons review

 I went with one of my friends to Jose and Sons Mexican restaurant on Glenwood Avenue and Pleasant Valley Road. I picked this place as I'd hear a lot of good things about it, and we were there early before the place got busy.  We were not impressed. The server was slow to get us our drinks, and did not get us chips and salsa, bur I could see his other tables got chips and salsa - turns out it was from a runner. We got ours eventually, (not from the server) but the first five minutes of our meal, we just stared at a bowl of guac and our two waters. No matter, maybe he was new. Maybe the kitchen was frying a new batch of chips. Maybe the bartender was new. While waiting, we noticed that the place looked like it needed new paint. In our booth, the pink paint was chipping off the wall. I was confused, because I thought they just moved here from downtown. They didn't even give the place a new coat of paint before moving in? The chips were warm, not hot, and the salsa was very sweet.
Read more