That code doesn't seem to produce the same results the OP is expecting, though.

We live in a world where a misplaced arithmetic operator can cause a fifty million dollar satellite to be destroyed before it ever reaches orbit, and where I don't think...

Well, except that...

Bizarrely enough, the modulo operator was the one I had to go to BOL to check up on--I don't think I've ever used it in SQL before! Bitwise operators I've...

Picture didn't appear on the e-mail--had to come here before it showed up. That happen to anyone else?

Lowell (6/16/2010)

---

Steve i made an ITVF based on your example, but i added a bit more to it;

i was thinking if i allow periods in the data, i need to...

bitbucket-25253 (6/14/2010)

For those that do not and only wish to earn points posting the code becomes a test of their ability to cut and paste, and not their knowledge of...

Oops! Make note to self: try answering the actual question asked rather than the one I made up in my head... :ermm:

I said it would return zero thanks to the cropped NULL, but even without that, surely it would return 4 rows, not 3? I would expect the values from Table...

So, when is it anticipated somebody will achieve SSC Guru? Sometime in early 2038? (Just before the world stops working due the UNIX time bug...).

And I'm in an even smaller shop where essentially I'm both DBA and SA! The arguments...

Mark me down as another believer in what Books Online said...I assumed that when it said the model database couldn't be set READ_ONLY that SQL would, you know, actually give...

I can think of a couple of situations where it would be helpful to run SQL services under a specific account:

a) You want to back things up across the network....

The accounts Local Service, Local System and Network Service are "virtual" accounts that have specific permissions. LocalSystem is essentially a local administrator and can access anything on the machine, and...

There's no such thing as a "general reason" why the load on your server has increased--you need to do some monitoring to find out what's causing it.