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.

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