Could try:

SELECT

sapaywk as [Week]

,SUM(CASE WHEN sacoy = 1000 THEN daawrhours ELSE NULL END) AS [Total Hours for Prime]

,SUM(CASE WHEN sacoy = 1000...

Michael Meierruth (4/30/2015)

---

Seeing this weird fiscal calendar really intrigues me - never seen or heard of this one.

I wonder how many different fiscal calendars there are out there in the...

You might want to dig under the hood more because indexes and primary keys are the easy part IMHO.

I'm more of a developer role, but there is only me, so I have to act as the DBA too.

I normally measure the impact of my queries when developing them...

stevenp333 (4/27/2015)

---

I wonder whether any companies use the DevOps idea to draw developers into a support role and then shut the gates behind them?

It might be that many large established...

Jeff Moden (4/26/2015)

---

xsevensinzx (4/25/2015)

---

BWAAAHAAAA!!! If someone gave me...

Eric Mamet (4/26/2015)

---

Thanks

It's very useful 🙂

On the NoSQL side... Why using NoSQL?

Is it because of the type of data you hold, or because of volume?

I think remembering that "Big...

Eric Mamet (4/25/2015)

---

I just saw a (new?) book entitled "Mastering SQL Server 2014 Data Mining"...

Following Microsoft BI developments, I was under the impression that "on Premise" SQL Server data...

Steve Jones - SSC Editor (4/25/2015)

---

xsevensinzx (4/25/2015)

---

Here is a good example I think where the number crunching cannot exist in the database.

I worked in the video game industry, specifically in...

Steve Jones - SSC Editor (4/20/2015)

---

RonKyle (4/20/2015)

---

...

But the number crunching belongs somewhere else. I have seen first-hand the improvements in performance that comes from moving business logic into...

I still find it funny there is such a huge wall in most companies where you have to remind people to collaborate with one another to get better results. It...

Steve Jones - SSC Editor (4/24/2015)

---

Good to see some of you doing code reviews. Not a lot of response, so I suspect many aren't.

Those of you doing testing as well,...

When I worked in the video game industry, we surely did code reviews all the time.

Now that I work in a different industry specifically with SQL Development, we don't only...

I'm no expert, but are there any issues with spreading out the refresh cycles per data source or do you have to do everything at once in one huge refresh...

Wayne West (4/14/2015)

---

lshanahan (4/14/2015)

---

Pick up a book called "No-Tech Hacking". It's certainly an eye-opener on this topic if it doesn't scare the **** out of you first.

Grant is right:...