Short and simple post this week. When setting up a Reporting Services Server this week, I added a user as a SysAdmin as they should have full access to the server to maintain it in the future. After setting up the user they tried to click in to the end of month reports folder…and couldn’t […]
In the previous 2 posts we have looked at how Rollup and Cube work. This time we’re going to look at how you might implement these in the real world. I don’t think ROLLUP has a great use in the real world (feel free to comment below if you have a real use for it). […]
Previously in Part 1, we looked at the ROLLUP keyword that can be applied to SQL Select queries. We are now going to look at the similar, but different CUBE keyword. As we saw last time, the ROLLUP keyword would sum each part of the GROUP BY and give you a running total. The CUBE […]
