Eric M Russell (8/27/2014)

---

Using T-SQL to parse EDI records is probably not the best way to accomplish whatever it is you're doing. You would get more useful advice posting this...

This appears to be a HIPAA EDI file. The 271 file layout can be found here (Though there are different versions, it will be important you know what version of...

I do want that step to fail in other situations. That is the catch, out of 5 possible failures I want 1 of them to count as a success...

Since it was appropriately brought up, I have to ask the following question and I do so without any sarcasm or irony because the last 20 people that I interviewed...

How about helping out at a local non-profit.

Or one that I have been looking at, volunteering to help teach computer skills to people, say at a shelter, or half-way house.

I do have many e-books, but still prefer paper. Admittedly I tend to treat them as the trophy of the hunt 🙂

So I have a DBA whom would be setting up the linked server. The part I am lost on is how to call a stored procedure on DB2 using that,...

Thank you.

It is indeed on an iSeries.

I expected it to be problematic, generally I don't have to ask here if it was going to be easy. 😀

Hiring too many people that are too similar, who may think alike, who may view problems the same way can lead to an environment that doesn't grow and expand, that...

Agreed!

However, I did just start here. I dragged the last place I was in from paper systems to nearly 2010. (It was 2012 when I got them to 2010, but...

That is what I was thinking as well. Essentially the management wants the existing code based fixed to handle errors without spending any time coding. None of us believe that...

Definitely ouch.

We have a large list of things to encourage the business to change, that is on it.

After digging into the data, and learning more about the history of this, it appears that the business has changed the logic of this about every other year, and even...

Thanks! I am using modulo to get to what I need. I just could not figure out how to in one set operation get the count to reset after 52....

Thanks dg.

Actually, this is connected to a large warehouse staging SSIS process, we are pulling roughly 50 tables from the db2 source, and it already uses concurrency. We still need...