opc.three (4/23/2013)

---

I agree with SQLBob in that I would never want to work for that person. Maybe someone can get this thread under their nose...maybe they'll listen to a chorus.

If...

Smart-assery aside,...

Doesn't matter what software you use - if you don't understand your data, or if you ask the wrong questions, you're going to get worthless results. Over and over I...

GilaMonster (4/18/2013)

---

Eric M Russell (4/18/2013)

---

Also, tell the candidate up front that all new hires are required to sign an "employment at-will" contract. If they don't measure up, then they'll just...

If some interviewer asked me to make him a PB&J, I'd tell him to throw my application in the trash, because I wasn't interested in working for such a clown...

Currently in the paleontology department's photo-laboratory, which is also the access path to the microscope lab. I'm the only permanent occupant, but almost everyone in the department wanders through here...

Slight hitch in the analogy - insurance payments cost something. Running DBCC checks costs nothing. What did this clown think he was saving by avoiding DBCC checks? A couple seconds...

Can't think of anything to add to this one, just congratulations. Pulling off a stunt like that has got to be a pretty major ego boost.

Thanks, Erin, that does indeed produce exactly what I need (except for the trailing separator, of course). I've been experimenting with both the self-join and FOR XML stuff today, and...

Yes, Erin, that's the kind of thing I'm looking for. I've used the for xml path('') syntax before, but I don't really understand what it's doing very well. I just...

Sean Lange (3/11/2013)

---

You could use a recursive cte to navigate through your table. This is not the fastest methodology but would be faster than a cursor in most cases. Maybe...

It's not obsolete if it still does the job it was designed to do. I've written my share of FORTRAN, RPG, COBOL and who knows what else over the years....

Bill Wehnert - The Tom Swift books (I had a set, too) weren't written by Asimov. http://en.wikipedia.org/wiki/Tom_Swift

I've been a gadget-geek all my life, since I was a little kid, dismantling...

Argh, never mind. Your comment about schemas bumped me in the right direction.

<shame-faced confession>

I was calling the correct procedure name, but from the wrong schema.

</shame-faced confession>

Thirty lashes with a wet...

Lynn Pettis (12/21/2012)

---

To paraphrase the problem originally posted. I have a parameter @MyParameter in a stored procedure that is defined, for example, as varchar(100). Occasionally the string value...