[font="Verdana"]It's beaten out in weirdness by "Stars In My Pocket Like...

Lynn Pettis (7/23/2009)

---

Usually, yes. Let's see, I think the topic right now is sci-fi/fantasy book appropriate for...

[font="Verdana"]Wait! There's a topic?

But while we're on the topic of kiddult fantasy, here are some highlights from from what I was reading at that...

[font="Verdana"]It was very, very funny at the time. :-)[/font]

[font="Verdana"]Paranoia is the one I remember ("The Computer is your friend!") But I also ran some private games based on...

GilaMonster (7/21/2009)

---

Read the book.

It's not bad. I didn't find it as good as the Da Vinci code, but it was a decent...

[font="Verdana"]Try something like this:

with

TotalHours as (

select sum([Hours]) as [Hours]

from #CompanyHours

),

CompanyHours as (

select Company, sum([Hours]) as [Hours]

...

[font="Verdana"]Try:

convert(datetime, cast(TransactionDate as varchar(8)), 112)

[/font]

[font="Verdana"]Ah well, I was close. :)[/font]

[font="Verdana"]You're welcome![/font]

[font="Verdana"]Okay, I thought about the code you posted some more, and I suspect that your originating date is actually stored as an integer in the form:

YYYYMMDDHHMMSS

That explains why you would...

[font="Verdana"]Okay, it looks to me as though you are trying to do the following:

1. display the start of the day on which the service order was created

2. display...

[font="Verdana"]DATENAME() does require two arguments. The first argument tells SQL Server which part of the date name you want (year, month, day, etc). The second argument is the...

Gaby A. (7/16/2009)

---

I have noticed a lot of folks may not seem to be familiar with the concept of BOL on their machines, thinking it is only an online resource...

Paul White (7/14/2009)

---

That always reminds me of a book - I think it was called "Good Omens" in which Conquest, War, Famine, and Death stopped at a cafe for a...

[font="Verdana"]I'm also thinking you could see...