I don't recall the index because I ran this test on a number of large tables and the outcome was always the same. It could be that al the tables...

Thanks for replying. Unfortunately we have only a live environment and I have DB level access only because this ia a cloud based setup and while we have a private...

I will be damned! That is a good idea! Unfortunately it wasn't enabled so it can't help this time but I checked and we have...

Thanks Jeff. I should have been more specific. I know you can setup things in advance to get this, I was looking more for something that is built in that...

Thanks Drew. Now the question is, what does SQL consider commented out vs not commented out in my example.  In the example I gave will SQL consider everything between teh...

Because we've foolishly allowed...

The below is in reference ONLY to the engineering of the software for use by personal PC that...

When some lower/entry level employee said something along the lines of...

I don't know if the time changes based on the type of change.  I have no idea why some items are future dated.  I do know from limited testing that...

Scott/Dennis - Thanks for such quick replies. I didn't provide the DDL for teh table originally so it's listed below.

CREATE TABLE [dbo].[TRACK](
[hRecord] [NUMERIC](18, 0) NULL,
[dDateIn] [DATETIME] NULL,
[sUserName]...

Jeff - I'm going with Scotts recommendation which sticks with CAST and not FORMAT.  That said, just out of curiosity do you know how much data/rows need to be involved...

Scott - That worked perfectly. Thanks!

Thanks for replying Phil

Thanks for replying

Scott - No worries, anytime you can provide some help it is much appreciated, same goes for all who take the time to reply.