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.

Steve - Thanks for adding to the discussion but I think I like Scott's simpler version on how to tackle this.

Scott - Do you know of a way to incorporate Count(hID) in there to get a count of the total number of rows per hPerson ? I tried it using...

Scott - a follow-up now that I've made this work.  so if the PERSOIN_HISTORY table had 5 rows for the same hPerson and I used teh criteria

AND row_num_desc = 2

I'm...

• This reply was modified 6 months, 1 week ago by  YSLGuru.

Thanks Scott