As I alluded to in my original posting...

Casting (or Converting) the date as INT or BIGINT may give you the wrong (next day)...

The basis of sp_executesql is that it is calling a Stored Procedure in your database, somewhere.  Stored Procedures are "precompiled". That is, the execution plan for the Stored Procedure was created...

Jason,

Just in case you still don't have an answer...

If you want to do the join as if TIME where not included in the...

Be careful... if any NULLS, answer will be NULL unless "Concatenate Nulls Yields Nulls" is turned off.

Frank,

Don't be so quick to give up on the data layer.  I had a similar challenge... I've posted ALL the code including the example data and table creation.  The actual...