Thanks Ryan... Yep... I should'a said "too"

Very interesting problem... thought I'd try the "exercise" a wee bit differently...

This one uses a "Tally" table... If you don't already have one, this is one way to make one...

Jeff,

If you are talking about importing with BCP, you can tell it to skip the first row by setting the first row (-F) parameter to 2.

If you are talking about...

Here's an example...

CREATE TABLE #yourtable (Time DATETIME,VALUE INT)

INSERT INTO #yourtable(Time,Value) VALUES('10:15:00',1)

INSERT INTO #yourtable(Time,Value) VALUES('10:15:10',0)

INSERT INTO #yourtable(Time,Value) VALUES('10:15:20',1)

INSERT INTO #yourtable(Time,Value) VALUES('10:15:30',0)

INSERT INTO #yourtable(Time,Value) VALUES('10:15:40',1)

INSERT INTO #yourtable(Time,Value) VALUES('10:15:50',0)

Actually, you can... well, sort of... make a call to xp_CmdShell and run a VB Script to ask the question and then pass it to a stored procedure.

It's a lot...

I've had great luch with Redgate's SQL Compare...

Amit,

That might be what you consider to be a temporary table but it's not a "Temp" table like what the user was requesting.  Temp tables live in TempDB and the first...

Not a problem... wasn't sure that's what you wanted but glad to help...

This could be easily modified to fit your needs...  It's an old example and I've not made many changes to it.

I used temp tables to keep from cluttering up my...

DOH!  I didn't even look at the code...

Basically, your saying you want to subtract 5 hours from anygiven datetime... this'll do just that...

SELECT DATEADD(hh,-5,somedatetime)

You can call functions from within functions provided they are "determinate"... it is, in my humble opinion, kind of a bad thing to make one function dependent on another.

So far as...

http://forums.belution.com/en/sql/000/110/02.shtml

Very nice...

That's cool...

You can also use NEWID() as the seed for Rand...  in the algo below, "RANGE" is how many numbers you want in the range of random numbers and "OFFSET"...