Ben and Adam,

I ran into a problem with Adam's script returning all records instead of just the overlap records.  I don't know if I did something wrong in changing the...

Rather than messing around with dates and times, why not just add the three hours to the Pacific Time date (see DATEADD in code below)?

Also, you may have missed some...

Since you've explicity created the target table, you should not be using "SELECT/INTO"... use INSERT INTO/SELECT instead.

Your code is correct... my next step would be a SELECT COUNT(*) on the B table to make sure that I only had one row because it sounds like you...

You forgot to post the error...

CHAR(13) "Carriage Return" and possibly follow with CHAR(10) "Line Feed"

The datafile type would certainly not be "Native" if you are trying to input CSV.

Recompiles can be caused by having DDL like table creation or Select/Into buried between normal DML code.  Define all tables and temp tables at the beginning of your code to...

Here's how I do it... runs nasty fast too.

------ Finds the date without the time (Time=00:00:00.000)

SELECT DATEADD(dd,0,DATEDIFF(dd,0,GETDATE()))

    AS DateOnly

>We'd like to be able to recreate their environment if needed.

See "Backups"?

I guess "Books on Line" is out of the question for you...

If you want a "live" example, perhaps you'd be kind enough to provide some live data and a description...

Ilan,

Not trying to be difficult here but I guess I don't understand the problem... please describe what you are trying to do instead of trying to write code for it... ...

The following example is straight out of "Books On Line"... modify it to handle your 5 nullable input parameters...

D. Create a stored procedure using a parameter default of NULL

The parameter...

Sometimes, you have to add to subtract...

WHERE DateOrder >= DATEADD(mm,-6,GETDATE())

Notice that we added a NEGATIVE six months to the current date.  Will also handle jumps across years, centuries, leap years,...

My suggestions in "bold" typeface...

Step One:

DECLARE A VARIABLE AS AN "INT"

SELECT THE MAX ID FROM THE SOURCE TABLE INTO THE VARIABLE

BEGIN...