OK so you need to be able to have access to the remote server. This typically means that the...

That depends. Is this just a single sql...

Grant Fritchey (10/12/2016)

---

jasona.work (10/12/2016)

---

Now this sounds like it has an interesting story behind it...

Grant Fritchey (10/12/2016)

---

I'm the guy who helped a developer send porn to our client list (I didn't...

Luis Cazares (10/12/2016)

---

And here's an example based on that article (you'll need to complete it):

SELECT machine_id,

type_id,

MAX( CASE WHEN attribute_name LIKE 'issuer%' THEN...

How do you know which rows are part of the same "row"? Please tell me it isn't the last part of the attribute_name value. EAV is a great tool when...

Good question Steve. I have to admit I haven't really noticed the index_id column because just a couple columns away is a description that requires no deciphering (type_desc). 😀

Lynn Pettis (10/6/2016)

---

Quickest way to learn what organizations NOT to use in job a search. This is the position I just got an email about:

Oracle Database Administrator

- 5+...

Ed Wagner (10/6/2016)

---

Sean Lange (10/6/2016)

---

Luis Cazares (10/6/2016)

---

Phil Parkin (10/6/2016)

---

Ed Wagner (10/6/2016)

---

Sean Lange (10/6/2016)

---

This may be the funniest thing I have seen in quite some time. You just gotta love 3rd...

Luis Cazares (10/6/2016)

---

Phil Parkin (10/6/2016)

---

Ed Wagner (10/6/2016)

---

Yeah, that's a...

Ed Wagner (10/6/2016)

---

Yeah, that's a good one. Be...

This may be the funniest thing I have seen in quite some time. You just gotta love 3rd party software.

ScottPletcher (10/5/2016)

---

Sean Lange (10/5/2016)

---

Thom A (10/5/2016)

---

Sean Lange (10/5/2016)

---

Be careful if you use this code as a starting point. It has scalar values being populated from the inserted table. This is...

Even better than converting it would be to eliminate it entirely. Cursors are horrible for performance and far too often they are used inappropriately. They have their place but if...

Is there any other kind? 😛

Whatever the spam was it didn't last very long as I can't see it at all. Was...

Eirikur Eiriksson (10/5/2016)

---

george sibbald (10/5/2016)

---

Lynn Pettis (10/5/2016)

---

george sibbald (10/5/2016)

---

well that's me done. I retire today so this will be my last post.

I made it into the top 30 posters at...