<!---
	Build a query of events that we will be able to
	test with. Some of these dates will span multiple
	days and overlap with each other.
--->
<cfquery name="qEvent" datasource="#REQUEST.DSN.Source#">
	DECLARE
		@event TABLE (
			id INT,
			date_started DATETIME,
			date_ended DATETIME
		)
	;
 
 
	INSERT INTO @event (
		id,
		date_started,
		date_ended
	)(
		SELECT
			1,
			<cfqueryparam value="#Now()#" cfsqltype="CF_SQL_TIMESTAMP" />,
			<cfqueryparam value="#Now() + 5#" cfsqltype="CF_SQL_TIMESTAMP" />
 
		UNION ALL
 
		SELECT
			2,
			<cfqueryparam value="#CreateDateTime( 2007, 04, 15, 0, 0, 0 )#" cfsqltype="CF_SQL_TIMESTAMP" />,
			<cfqueryparam value="#CreateDateTime( 2007, 04, 15, 23, 59, 59 )#" cfsqltype="CF_SQL_TIMESTAMP" />
 
		UNION ALL
 
		SELECT
			3,
			<cfqueryparam value="#CreateDateTime( 2007, 04, 8, 10, 30, 0 )#" cfsqltype="CF_SQL_TIMESTAMP" />,
			<cfqueryparam value="#CreateDateTime( 2007, 04, 10, 4, 45, 0 )#" cfsqltype="CF_SQL_TIMESTAMP" />
 
		UNION ALL
 
		SELECT
			4,
			<cfqueryparam value="#CreateDateTime( 2007, 04, 4, 12, 0, 0 )#" cfsqltype="CF_SQL_TIMESTAMP" />,
			<cfqueryparam value="#CreateDateTime( 2007, 04, 5, 12, 0, 0 )#" cfsqltype="CF_SQL_TIMESTAMP" />
 
		UNION ALL
 
		SELECT
			5,
			<cfqueryparam value="#CreateDateTime( 2007, 04, 29, 9, 0, 0 )#" cfsqltype="CF_SQL_TIMESTAMP" />,
			<cfqueryparam value="#CreateDateTime( 2007, 04, 29, 12, 0, 0 )#" cfsqltype="CF_SQL_TIMESTAMP" />
	);
 
 
	SELECT
		*
	FROM
		@event
	;
</cfquery>