Yes, I've verified that the query returns non-zero values by running the...

Thank you Sachin, that worked. I've changed the SELECT to look like this:

SELECT fcnItems.DrugOrSupply, fcnItems.InventoryActionID,

fcnItems.ItemPackageID, fcnItems.OldItemNum,

fcnItems.ItemDescr, vw.InventoryIn,

vw.PharmacyOut,

(QtyOnHand/(@NumDaysBetwDates/@NumDaysToStock)+1) StockingLevel,

((@NumDaysBetwDates/@NumDaysToStock)/2+1) ReorderLevel,

vw.QtyOnHand,

IIf(QtyOnHand<((@NumDaysBetwDates/@NumDaysToStock)/2+1),(QtyOnHand/(@NumDaysBetwDates/@NumDaysToStock)+1)-QtyOnHand,0) NumToOrder

FROM dbo.fnItemsIssuedToLocBetwDatesNeedItemType(@DrugOrSupply, @BeginDate, @EndDate) fcnItems

INNER JOIN vwItemQtysOnHandAllItems_SQLViews vw

ON fcnItems.ItemPackageID...

Here's the exact error messages:

Msg...

And where are you interviewing?

No, I think that page says that the 32-bit version is for both 32 and 64 bit SSRS 2012.

The people in tech support at my work said the only version of SSRS/BI tools for SQL 2012 was the 32-bit version. So that's what I've got installed now.

GeorgeCopeland (3/14/2016)

---

lol ouch sorry Rod.

I am IT support for everyone who loves me. It is ok.

I always set their photos folder to cloud storage somewhere. Everyone has some.

All Windows 10...

This isn't a backup horror story, but a Windows 10 upgrade horror story.

I've got several machines at home. Desktops, laptops and one Surface 3. They were all running Windows 8.1...

Chord77 (3/11/2016)

---

CMMI is not Agile nor Waterfall, it describes best practices which can be applied to either.

Another thing to remember is that the Waterall has feedback loops much like agile,...

Thoughtful article, Steve. I've been in my current job less than a year, so in fairness to my employer and colleagues, I really may not have an accurate view of...

Wayne West (3/9/2016)

---

Ars Technica has an article on Slack[/url] today. When Steve published this editorial, I had no idea what Slack was, and no interest in it as I...

HA! HA! HA! (bitter laughter) Use Slack? Are you kidding? Where I work there are a lot of resources which are blocked. Slack is just one of them. Pigs will...

I am looking forward to Thursday's event. I'm especially looking forward to SQL Server 2016's Always Encrypted functionality. That has the potential to being very useful in our environment, addressing...

I agree with this and have been thinking of things I can automate in my current job. What does surprise me though is how little things are automated already. In...

Kyrilluk (3/2/2016)

---

Gary Varga (3/2/2016)

---

I have been seriously thinking about this over the last couple of days and believe that a Neural Network can be audited. Not directly, as both Kyrilluk...