Eric M Russell (4/5/2016)

---

Rod at work (4/5/2016)

---

I got caught up reading people's replies to this thread, when I realized that this thread indirectly points out something I feel most...

I got caught up reading people's replies to this thread, when I realized that this thread indirectly points out something I feel most of us haven't experienced. That is,...

tindog (4/5/2016)

---

Rod at work (4/4/2016)

---

Lynn Pettis (4/4/2016)

---

As my youngest daughter nears graduation from high school and I am officially single, I would consider moving for a job unless outside factors...

Thanks, Beatrix.

Lynn Pettis (4/4/2016)

---

As my youngest daughter nears graduation from high school and I am officially single, I would consider moving for a job unless outside factors encourage me to stay...

At this point its just a plain, vanilla let the user enter it by hand on the SSRS report interface. I've restricted it to an integer data type and that...

Would I move for a job? Yes, absolutely! But not just any job, it depends upon the job, company, location, compensation, etc.

Eric M Russell (3/28/2016)

---

It's important for a software tool, especially a database management tool like SSMS or VS, to provide a visual queue that environmental context has changed. I believe...

Oh man, have you hit upon a topic that really bugs me. At my new job there's a software project that I'm help maintain that we purchased from an out...

I found the problem. I was calculating one of the values wrong.

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.