ArnolddG (6/9/2015)

---

Thanks for your help Alvin,

That works okay.

One more thing. My query is about 140 lines long.

Is there a way to do the If Then on one select column only...

You cannot use named parameters with the OLE DB connection. The parameters in the mapping page are by ordinal starting with 0, so you need to map:

Variable Name ...

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...