Reformatted also to be easier on the eyes.

I'm pretty sure you need to remove the period key so that it pivots correctly, but I can't be sure without seeing the...

Ya we all remember those 1-2 guys, I remember that being a good deterent for me ever wanting to be assiciated with that title. I wasn't ever shooting for...

If you have data and you're group by are fine the sum(case) will always work.

Can you post the full query, I'm sure it's really simple to fix!

WayneS (8/8/2011)

---

On a different topic, for those that have a blog, what do you'll think of using GoDaddy for hosting a domain and WordPress blog?

What do you'll think of...

Unfortunately I have this install outside the default path on my 2005 box. However this is the filename : SqlWb.exe

For 2008 R2 express : C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe

Steve Jones - SSC Editor (8/8/2011)

---

WayneS (8/7/2011)

---

For those of you that do consulting, and for those thinking about it, what do you'll think of this? Steve, what do you think...

Steve Jones - SSC Editor (8/8/2011)

---

Ninja's_RGR'us (8/7/2011)

---

Very interesting topic Steve.

Could it be possible that there's a missing link in this part of the editorial?

This piece talks about the problems...

You're 99% there.

you need SUM(CASE WHEN ...)

GROUP BY Not pivoted column.

I've just confirmed your findings on our servers. Works exactly as you prescribed with 2k5 and 2k8 (R2)

I've done 1 extra test by putting the db in compat mode...

http://www.sqlservercentral.com/articles/Tally+Table/72993/

How much are they looking to save by not purchasing the licenses?

The human capital required to do the upgrade can be extremely extensive and it might be good to avoid...

Looks like you've been down this road by why upgrade to 2005? It's already OUT of support.

It's the same amount of work to upgrade to 2008 R2 than it...

Denise McMillan (8/8/2011)

---

I have a question about the query you sent to check if the backup was running. It worked great, I could see its' progress and knowing it was...

There's an edit attachement button bottom right of the post page. You can also watch for + button if you don't see...

halifaxdal (8/8/2011)

---

Ninja's_RGR'us (8/8/2011)

---

How big are the datafiles (not the backups, but the restored files)? Express can't go above 4GB in 2K5.

Does the serer have permissons to write in that...