Your derived table query isn't returning any rows for those periods so there is no row to apply ISNULL to. You need to provide data for those months with...

With...

Grant Fritchey (5/22/2015)

---

Question for the crew since this is a fairly international audience, plagiarism

I understand that some cultures look at it very differently than most Western European-based ones do. There's...

Unfortunately you can't do it natively, you have to use javascript. Here's a link on how to do it, http://www.bidn.com/blogs/BrianKnight/ssis/972/ssrs-action-to-open-a-url-in-a-new-window.

When running in SSMS I believe it is running under the SQL Server Service account. I know it is not running under the SQL Agent Service account and that...

GilaMonster (5/22/2015)

---

Hate it with a passion. Noisy, crowded,...

Question, how many of you work in an open work space? If you do, what are your thoughts?

My employer just finished a renovation and I'm moving into an open...

jasona.work (5/22/2015)

---

Ah, the Friday before a 3-day weekend here in the US...

Everyone smart took the day off, everyone who couldn't take the day off is trying to figure out how...

ROW_NUMBER is usually the best way to do something like this. Here's an idea:

DECLARE @test-2 TABLE

(

Auto_ID int,

...

GilaMonster (5/14/2015)

---

Question for the people here...

Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially because when I...

Vertigo44 (5/7/2015)

---

ROW,NOTE_ID, NOTE_SERIAL_NUM, NOTE_STATUS

1, 366834292, 333040947, 8

2, 366834292, 333054601, 2

3, 367096281, 333293527, 2

4, 367096281, 333282008, 8

5, 368005352, 111111111, 2

6, 369005341, 111111100, 8

I need from this subquery only the NOTE_IDs that...

See the answer in your other post, http://www.sqlservercentral.com/Forums/Topic1683862-392-1.aspx

I haven't done much with encryption so I wasn't sure if this was possible and it was...

Since the Key and Certificate reside in the other database you need to change context to that database. I believe you can do it using Exec sp_executesql something like...

Can you provide the DDL for the table?

Is the Company Name in the same table?

You could do something like this:

IF OBJECT_ID('tempdb..#company', 'U') IS NOT NULL

BEGIN;

...