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.

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