A sample of useful Firebird stored procedure script

This stored procedures script will display a report of what are the items the customer purchase within the given period of time.

One of the things I like with Firebird is their stored procedure features. In my experience with MSSQL and MySQL5 doing stored procedure has been easier with Firebird and yet powerful. I fell in love with it and making stored procedure as my usual solution for data manipulation.