I saw a "67" as an average and thought that was incorrect and that caused me to take the post down until I could double check.  It's actually correct.  Here's...

Sorry... something went wrong and so I took the post down.  I'll be back.

• This reply was modified 3 years, 4 months ago by Jeff Moden. Reason: Fixed output and code. Had the Weekdays and Weekends reversed
• This reply was modified 3 years, 4 months ago by Jeff Moden. Reason: Error in post. Took the post down until I can fix it

Hello,

I have a task where I need to find the task of a rental price where the rental price is different when it's a weekday vs the price when...

Definitely a thumbs up for NOT using the awful DW datepart.  Long live DateSerial# ZERO! 😀

If you would post more detailed information (like you've been asked before), it 1) wouldn't take so long and 2) people wouldn't give up on you.

I'll point you to the...

That sounds good and right, Jonathan.  I tell people that good splitters shouldn't make any assumptions and that it should return EVERYTHING that's between the delimiters, an empty string if...

@Webmaster finally responded.  It turns out that Steve Jones is no longer the "watcher" there.  I got a hold of Steve through his email and he said they'd notify the...

Actually, they stopped working on or about Oct 26th and, yes... they're still broken.

I did finally get an acknowledgement for @WebMaster on this site (Steve is no longer the watcher...

I'm no expert on the subject because we have an "Infrastructure Group" where I work but I wonder if a simple "Clustered Server" would do the trick here.  They have...

The reason why it produces an error is because the first thing to qualify in the CASE expression is an INTEGER and so the resulting column formed by the CASE...

They stored it in an SQL_Variant with the wrong base type. 😀

We have a reporting database.  It has 2 schemas... Build1 and Build2.  We don't mess around with triggers or the schemas.  We created a 2 synonyms for each table... 1...

@jonathan-2,

I recently had reason to revisit this article and I found a bug in the code.  It does not preserve leading spaces in the individual elements.  If an element is...

Not that I've ever heard of.

How many characters are in the column that you want to split? I ask because, since your column started off as NTEXT,...