I'm writing a stored procedure to move the data from the DBQL tables to another table for storage. I'm using three variable to allow me to separate the logs by year. This is the first Stored Procedure I've ever written and I am fairly new to Teradata as well. Here is the definition of the SP:
Thank you guys. You have been a great help. I found out that one of my problems was that I wasn't passing the TIMESTAMP all of the precision that it was expecting. Of course my other problem was my syntax. You guys are the BOMB!