In building SQL queries, Reports, and Vista Views many users are using more resources than necessary. SunGard Higher Education has many functions and stored procedures provided in the database which can be leveraged to skip extra works such as SQL Joins. This session will introduce many built-in functions and procedures that can benefits schools and we will look at building our own SQL functions or stored procedures for returning data.