I think that Microsoft is the sole authority on what B-Tree means in their systems, although like everyone else I learned that the "b" in b-tree stood for binary and...

This could be done in one statement, or with a function, but the CTEs make it a little easier to read. The first CTE uses the STUFF() function to...

I'm late to the party on this one, but got it right from reading the Inside SQL Server 2005 books. Kalen Delaney stressed that it was balanced. ...

Yowch, really sorry to hear that, Barry. I will shift to you all the good vibes I can pour into the Force.

Jack, the last time I swapped emails with Flo, they were getting ready to launch a big project at his place of work. He told me it might...

Lynn, with all that vacation I would have expected you to be more patient.

Did you leave your halo at the beach? 😀

If it's any help, I always think of him as "Crawfish" (yes, I know it's Crawford). 😉

Good to see you back posting in the main forums, Jack. ...

Is this what you're looking for?

-- the ctes get you the date

;with cte1 (DateColumn) as (select distinct dateadd(day,datediff(day,0,DateColumn,0) from dbo.MyTable)

,cte2 (DateColumn,rowID) as (select DateColumn,row_number() over(order by DateColumn) from...

Do you have a calendar table of some sort that designates holidays and/or weekends?

Psssst Trudye.

"Champion" is Jeff's title. His name is just above it.

Or shall we start referring to you simply as...

Good question and interesting result. I'm surprised that it accepted mixed dots and dashes as separators in the date. I thought it would break if I...

Good to hear, Jack 🙂 🙂 🙂

Barry, congratulations on getting my question right on the first try. I predict it will be very profitable for you. 😉

The "cannibalism" episode from the last season of Gilligan's Island was banned by the sensors.

It was a kindler, gentler time.

There is no need to save your spreadsheet as a text file. From the Import Data task, you should be able to select a datasource called "Microsoft Excel"...

Thank you very much for taking the time to set up the problem so nicely. While I am having to guess at your expected output from the sample data...