<--- --------------------------------------------------------------------------------------- ---- Blog Entry: Ask Ben: Displaying A Simple Event Calendar Month With ColdFusion Author: Ben Nadel / Kinky Solutions Link: http://www.bennadel.com/index.cfm?dax=blog:663.view Date Posted: Apr 29, 2007 at 8:45 PM ---- --------------------------------------------------------------------------------------- ---> DECLARE @event TABLE ( id INT, date_started DATETIME, date_ended DATETIME ) ; INSERT INTO @event ( id, date_started, date_ended )( SELECT 1, , UNION ALL SELECT 2, , UNION ALL SELECT 3, , UNION ALL SELECT 4, , UNION ALL SELECT 5, , ); SELECT * FROM @event ;