I always considered myself SQL advanced however when I came to the following sql code, I couldn’t figure out the correct answer: The below table has 5 rows(from on the first sql ), what will be the result of the
Google Cloud Platform – Introduction
I’ve been trying Google Cloud platform for a while and this article is about my experience with it. If you’re interested, you can get free trial for a year ($300 worth of credit). Initially Google Cloud platform looks daunting –
SQL server computed field
I recently came across this very interesting rounding issue in MS SQL server. Originally I thought in order to keep computation in highest accuracy possible, I should use the max allowed precision, i.e. on SQL server a decimal(38,18). However after definition of
Microstrategy movingsum
Have been using Microstrategy 9 for a while, had a moving sum problem recently. The customer basically needs moving sum for the past 12 months for each state/branch. Of course the month is based on accounting period, i.e. 1 May