Adam is correct... basically, there is no way to store just the Month and Year in a datetime field.  In fact, you cannot store a "formatted" date in a datetime...

BCP... read all about it in Books-on-Line then post back.  I'll be happy to help once you are familiar with the terms and capabilities.

>The problem is that you have no idea what your are doing.

Apparently, Joe, you don't either because you provided no help to solve the problem... only caustic criticism on a...

Yes, there is, kind of, but I don't know if it will work with a cursor (I avoid cursors) and it uses a temp table (no so bad if proper...

Yeah, you're right Frank... Not enough coffee

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