If you're there at that moment, and...

Corporatewide Shareholder Value?

Good grief, guys. Hey Patrick, welcome to "the Swamp", grab a martini if the still's running.

This debate is going for... four pages now? I personally don't care about...

So, while I still think you're setting yourself up if you're not incredibly careful, here's one of the most cautious ways to approach this to make sure the data can't...

Briceston (7/27/2014)

---

I have a SSIS package that consists of a Foreach file Enumerator and a Foreach ADO.NET Schema Rowset Enumerator. Within Foreach ADO.NET Schema Rowset Enumerator, I have DFT that...

This appears to be a reporting pivot of timeline rows for a report of some kind regarding the diagnosis applied to a patient.

Look to the report. Can this be...

Hrm, good point, my apologies. I read it too quickly. Habit on...

Auto, you need to (Partition by item order by changedate) for that to work.

Edit: see below, sorry.

Does this data only work with dates, and never times (such as what GETDATE() would return?). The reason I ask is that it basically skips a day worth of...

It's alright to be grumpy, just remember we're all volunteers too, and we're trying to make sure we don't waste your time either. A few clarifications cleans up a...

Check to make sure they didn't alter your row terminators. IE: CR/LF became LF. I usually see this when an entire document loads up as a single line.

DiabloZA (7/27/2014)

---

The idea is that even though I'm looking back to current Monday if the week, I don't want to pick a record again once I have already looked at...

For your connections to SQL Server, are you using passthrough queries to procedures, or are you using local views which call through the ODBC links to each table in the...

I find that any 'direct hire' jobs are in the same boat as the agencies with usually not having the technical wherewithal to properly define the position they're trying to...

Why wouldn't you want a face to face? I personally want to see their offices, check out their paperwork, see their non-compete contracts, etc.

It's also a chance for your...