Serqiy,

The only problem I see is that there are folks that are over 99 years... just change the VARCHAR(2) to VARCHAR(3) and you're golden because you accounted for everything else...

Jennifer,

I agree with Serqiy...

SELECT STR(yourcolumn,10,4)

FROM yourtable...

Not quite true... table variables are also connection sensitive...

Jesper... I don't believe your formula works correctly...

select (datediff(d, '20060213', '02/26/2006') + 1)/7 - datediff(d, '20060213', '02/01/2006')/7

select (datediff(d, '20060213', '02/27/2006') + 1)/7 - datediff(d, '20060213', '02/01/2006')/7

Ya just gotta love what Microsoft did with their execution plans ... I absolutely agree that both execution plans came out the same for...

Funny, I just posted a similar solution to remove everything except 0-9...

If you don't already have a "Tally" table, now's the time to make one... here's the code to make...

Govinn,

If you don't already have a "Tally" table, now's the time to make one... here's the code to make a Tally table...

--===== Create and populate a Tally table...

Yep... for starters...

Steve,

What is the datatype of the column you are storing this data in?

Just a couple of things...

If the Inserts will, more or less, be in order by [Date], then having a Clustered Index on date will be OK, otherwise, the Inserts will...

Yeah, but, good Lord... don't use a cursor to find and delete dupes (or for anything else for that matter)... here's a fully commented template for deleting dupes... you could...

Ron,

This is what I posted on the "other" forum you posted the same question on...

> First, I have to do due diligence... what you're suggesting is, for so many reasons,...

Bullfrog,

I'm thinking that your times are a bit screwed up in your example data... they're all 8:23:00.  But, I'm thinking we get the idea...

The hard part is, I can figure...

If you just want duration and not actual CPU seconds used, then something like this works...

--===== Declare a couple of variables to measure duration

DECLARE @StartTime DATETIME

DECLARE @EndTime   DATETIME

Hi Tushar,

Look up "cross-tab reports" in Books Online... it has a great example of how to do a "Cross Tab" which some call a "Pivot".  If you want true pivots,...