The only page I get that tells me a date right now seems to imply that I'm running September 2007 locally.

Of course - when you run in "offline only"...

What date modified? I was under the impression the only date tracked on a stored proc is the date it was created. That only gets updated when you...

It depends on what is causing the "abort". If you mean - are there conditions where a long-running SQL task could stop others from running? Yes, if the "first"...

Try windows update (under optional downloads). It prompted me for an updated one the other day.

you have to take into account the number of "significant positions", meaning - the precision. The purpose of FLOAT is to store "approximate numbers", so some of the display...

..and that all leads to a question of definition. "Full week" vs partial, which weeks gets included in which year. That's all driven by what you are going...

...which of course, would be true if you...

Carl - my understanding is that it's some more complex version of one being multiplied by the other. so - both factors are "spread out throughout the NEWID()".

So -...

Sounds like you might be looking for a "pivot query" solution. Something like:

Select M.BookId, M.booktitle,

sum(case when d.status=1 then 1 else 0...

I'm sorry - perhaps it's too early on a Monday. What's the actual question?

Jeff Moden (10/15/2007)

---

Heh... too bad I don't have SQL Server 2k5, yet... would be an interesting test 'cause, you're right, Regex is very fast.

The fastest option, though, would be to...

It's an interesting dynamic, because I've been in the scenario a few times. I've learned though that the majority of times - those who want to put you on...

The other way to do that is to use regular expressions, especially when you get into really ugly string matching/parsing. Setting up the regex methods are damn fast too...

for better or worse - I haven't received a PM - so the whole communication is right here.

what did you put in to define the alias, field by field?

What settings do you have (field by field) in the TCPIP settings under

SQL Server 2005 Network Configuration Settings,...