I can't truncate the table because I'm only updating/reinserting some records, not all.  That's why I have to specify the date range in the delete statement.

An update is not an option here. 

Any other ideas?  I'm getting desperate....

There are around 1.5 million rows in the physical table.  I'm trying to delete around 70K-100K rows on the delete statement.

Thanks, Matt.  But I'm not sure I'm following.  There is an index on the date column. (Non Unique, Non Clustered).  I'm looking to delete everything in the physical table in...

Sorry, Lynn. Appreciate your effort on this as well. I feel fortunate to have access to so many exceptional SQL minds; it's just fantastic.

Thanks to everyone!

Thank you, Jason! I've not used STUFF before. Works great.

The only thing I have against these nice simple answers:

REPLACE(RIGHT(CONVERT(CHAR(19),DATEADD(ss,@Time,0),100),7),' ','0')

and

CONVERT(varchar(20), CONVERT(time, DATEADD(SECOND, @time, CONVERT(datetime, CONVERT(date, getdate())))), 100)

...is that they appear to display the time as 07:30PM rather than...

omg.

I'm taking that one.

Thank you, Michael!

To provide more background on this, our environment is a little different than expected so I had to take into account the early (1-3560 seconds) 12am times as well as...

Thanks everyone for your assistance! I've been working with LinksUp original option with a few modifications to handle the AM/PM for midnight and noon. I think this is...

No, I didn't specifically, but think I figured out the issue anyway. I actually tried hitting Run to preview the report, based on a forum reply elsewhere on another...

Oh my goodness. Compatibility View did it.

Thank you so much, never even considered this to be the issue!

Thanks for everyone's help!

It's using stored credentials in the shared datasource. Is that what you were asking?

(This is how we set up the security for all of our reports.)

Could this impact things?

The permissions to the report are inherited from the folder it's in, which is inheriting from the root. So nothing special about the report specifically.

This is just weird.

I appreciate...

Unfortunately neither one helped. Same behavior as before.

Anything else?