I'm not arguing what management is calling it - I'm pointing out those are apples and oranges. What I was getting at with the year comment was that academic...

First things first - you REALLY should be putting the academic year into a calculated field in your table so you don't keep recalculating it. Make it persisted, and...

See if this logic fits - it sounds like you know the call-in frequency (in the case below - 10 minutes) and/or the maximum time of a call. Either...

Thanks - I had to wiki it to make sure I knew what it meant. I guess the link isn't very clear in my previous post.

Good word...

Well - it's certainly not so much fuzzy as it is flexible.It's more like Patindex than it is about longest common search, just with quite a few more options.

I was...

.50$ word there....hehe

non-repudiation

Agreed. No qualifiers, etc... It's a passive node - period, so no extra licensing.

if you strip out the 'CET WED' from the middle, CAST would work.

Something like

select cast(left(@dte,charindex(' ',@dte)-1)+substring(@dte,charindex(' ',@dte)+8,50) as datetime)

Two things to check. One is that you might have the "implicit transaction" setting turned on, which means EVERYTHING it wrapped in a transaction. Check the properties of...

...or... (come on Jeff, you KNOW what I am about to say)....

Regular expression CLR functions would do that as well.... But you still need a search string to start...

That's my point - by purchasing or upgrading to the 2005 licensing (even if you USE SQL2K), you skip over all of the nastiness having to do with virtualization that...

How do you plan on searching for this? Do you have a list of announcement you want to look for?

If you don't - then you're going to need to...

John - I tend to agree that there are lots of grey areas in the licensing documentation (on purpose I suspect, with the hope that orgs will err on the...

with the dashes - that's a non-standard format... Try this...

select replace(convert(char,cast(datein as smalldatetime),111),'/','-')....

what kind of shape is the tempDB in? how big, how many fragments, growth factors, etc...?

Do you have autoshrink on anywhere?

and - why, why, why all of the row...