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"...

Here's a self standing sample that you may run with impunity...

This turned out to be a bit long winded because an ORDER BY in an UPDATE in the presence of...

FROM #YourTable y,

        dbo.Tally t

Ok... now I'm confused That is a Tally table in your code, isn't it?

Althought the Jury is still out...

Thanks for the great feedback, Kenneth.  Yep... I know the double barreled last names need some help but James insists that they will all be hyphenated... I sure hope he's...