Tonight, I'll be in a theatre orchestra pit for the 5th time this week.  No need for prayers - I need...

Jack's just kinda boring, that's all. It's not "bad", like undrinkable or anything, but it's not interesting either.

As someone who doesn't know any better, how does a team of developers then share the standardized objects that might allow them to be more productive? (views/unit tests/stored procs/etc.) Is...

But have either of you ever been to Belgium?

"Never give up! Never surrender!" ~ Commander Jason Nesmith

SEAN LANGE HATES BABIES! film at 11...

You don't need to do that to get counts by month. I'm sure there are multiple ways to do this, I would use a calendar table of some sort and...

yeah, I don't think you need all that processing either, if your file format will always be <something>_files_YYYYMMDD.xls

SELECT SUBSTRING(@Text, PATINDEX('%.xls%',@Text) - 8,8)

What are you really trying to do here? Why overwrite, when you could just capture the history by adding a date of transfer or something and have the whole history?

A Møøse once bit my sister...

Honestly, sounds maybe like you just need to ask the business user to explain their business and what they are trying to accomplish, then once you understand that, model how...

Or, if you wanted to go whole hog and just split everything out from your string, then access just the parts you need, you could use the DelimitedSplit8K approach a...

A

Always look on the bright side of life

For life is quite absurd,

And death's the final...

I think the short answer is "synonyms"

Yeah, somebody's tried that before. Didn't work out so well for them.