In SQL, you cannot use a column alias in the where clause that's been defined in the select clause, for example an alias created by a sub-select. Today i discovered a derived temporary table workaround, this creates a table with my select statement and this allows me to use the alias with a conditional statement. [...]
Archive for September, 2010
Sep 05 2010
Call of Duty Ratio Calculator
This is something i wrote a long time ago for a buddy of mine, he wanted a way to calculate the K/D ratio for the Call of Duty game. This was so he knew what he needed to reach a higher ratio. This is something he still finds useful so i wanted to share this [...]