K.  I was just checking.  To paraphrase "Red Green", "We're all in this together and I'm pullin' for ya."

Your solution did not convert to 12 hour or include AM PM designation.

Ha, I know you suggested against using FORMAT but that is what I ended up doing .

FORMAT(CAST(field_here...

SGAB, does any one have a decent example of an Instead Of Update trigger that will handle more than one bloody row at a time and also ONLY update the...

Ok... they've fixed the notifications issue and it appears have been doing things correctly for a while now.  Does anyone have any more problems with that issue?

I'm with Rick and ZZArtin on this one.  But, I WILL put a positive spin on things...

It's a funny thing... I didn't realize, when I first started, how much investing...

It took you longer to post the question than it would for you to look...

Replace GETDATE() in the following with your datetime valued.

 SELECT CONVERT(CHAR(10),GETDATE(),110)+STUFF(RIGHT(CONVERT(CHAR(19),GETDATE(),100),8),7,0,' ')

Some will suggest using the FORMAT function... I strongly recommend against that.  See the article at...

I try to avoid the use of things like the Week and WeekDay date parts for multiple reasons that would take too long to go into here.

Based on what you...

On that note, do you actually have permission to do that from the company and is there any PII in that database where it shouldn't be sent even if you...

Do you really mean 48 and 24 hours in your...

The only time I use the COPY ONLY option is if I need to send the actual file someone.  I don't want a file listed in MSDB for my backups...

As a bit of a future-planning sidebar...

If that table ever becomes fragmented, you may want to someday defragment it.  To keep the file group from having a whole bunch of...

BTW... it's a really good habit to add brackets to the name of the file group.  It'll let you live for HISTORY without them but it's absolutely required if the...

That's it.  No need to drop...

Adding another post just to make the forum software actually see 2 pages of posts.