I know that you guys have moved on to deeper issues but I just wanted to post an alternative query I developed for returning races at a minimum specified time...

Could be anything that generates the data in the form desired. Once the table proper has been replaced with the table valued function, he can be free to change it's...

Couldn't you create a table valued function and then do a global find and replace, replacing the table name with the name of your table valued function, e.g., "Race_Report" =>...

You're right of course. My solution only works for the specific case where the time difference is consistent and even multiples of 5 minutes.

Ok, let's give it another try...

declare @races table(raceno int identity(1,1),racedatetime datetime)

insert into @races

(racedatetime)

SELECT '2011-02-20 13:50:00'

UNION ALL

SELECT '2011-02-20 13:55:00'

UNION ALL

SELECT '2011-02-20 14:00:00'

UNION ALL

SELECT '2011-02-20 14:10:00'

UNION ALL

SELECT '2011-02-20 14:20:00'

UNION ALL

SELECT '2011-02-20 14:25:00'

SELECT

*

FROM

@races

ORDER...

I re-read your original question. The query I provided doesn't directly address your issue. I apologize. I should have taken more time to interpret you question. I'm experimenting and hope...

Try something like this

;With RaceRows AS

(

SELECT

ROW_NUMBER() OVER (ORDER BY racedatetime) AS row,

...

Here's a very quick way to insert 60,000 sequential numbers into a table:

CREATE FUNCTION [dbo].[Numbers]

(

@MaxNumber int

)

RETURNS TABLE

AS

RETURN

(

WITH

L0 AS (SELECT 1 AS c UNION ALL SELECT 1),

L1 AS...

A quicker way may be to use the SQL Server Database Publishing Wizard. (See http://www.microsoft.com/downloads/en/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en) It works with SQL Server 2000 and 2005.

It will generate a SQL script to transfer...