The problem here is that you don't quite understand how tables work. Columns are supposed to be attributes. But a year- month is not an attribute; it's a measurement of...

The last time I looked, the GAAP had over 157 different fiscal years. The best way to do this is to set up a calendar table that maps your fiscal...

Would you mind saving us the trouble of reading your mind and posting some DDL? It would also help if we had some sample data to work with.

Your simple table is very badly done. You don't know about current data types....

First of all, there is no such thing as a case statement in SQL. We have a case expression, which returns a single scalar value. But more than that, your...