Actually, there is a 6th book in the trilogy. "And Another Thing", written by Eoin Colfer.

From Wikipedia:

The Hitchhiker's Guide to the Galaxy

The first five novels in the Hitchhiker's "trilogy"...

Why all the complication with REPLACE(REVERSE(STUFF(REVERSE ...

I typically do this to get a comma separated list:

SELECT STUFF((SELECT ',' + name AS [data()]

FROM sys.columns

WHERE OBJECT_NAME(object_id) = @TableName

ORDER BY column_id

FOR XML PATH('')),...

Thank you Luis. That seems to do the trick, at least in a small test. Overnight will tell.

Now I'm really confused.

I'm testing this out in BIDS, right? Watch the appropriate boxes turning green. Start, then Task B, then LRT. Then BIDS says the package...

John Mitchell-245523 (9/24/2014)

---

Tom

I think you need to change the precedence constraint between C and D so that it evaluates to True on Success OR if @Variable = True (where @Variable...

I should mention: this is on 2008 R2. Also, the actual task flows are much more complicated, especially the right hand side. There are many more tasks and...

I would tell newcomers: Don't be afraid to ask for help. I've seen too many people (especially new graduates) struggling for what turned out to be days because they...

I would say that "it depends". Years ago I worked in product development environments, where the software had to be installed into the customers existing environment. So yes,...

One big difference is that with sp_ExecuteSQL you can define parameters external to the @SomeSQLStatement variable, thereby reusing the dynamic sql with...

Jim P. (1/23/2014)

---

djackson 22568 (1/23/2014)

---

A great way to handle it, but sometimes, when done properly and without malice, it is beneficial to point it out to the group inside the...

Thanks guys. Cross Apply did the trick. I seem to have a block on that; it just never occurs to me to use Cross Apply.

Cheers,

Tom

I taught Introduction to Programming for a couple of semesters (evening, adult bachelors level). One of the things I emphasized was having well-commented code, but I would mark down...

Gary Varga (1/16/2014)

---

Luis Cazares (1/15/2014)

---

Tom Bakerman (1/15/2014)

---

Luis Cazares (1/15/2014)

---

In my experience, doing just enough to complete a job has resulted (most of the times) in errors that require extra work...

Thank you Craig, exactly what I was trying to say as well.

Luis Cazares (1/15/2014)

---

In my experience, doing just enough to complete a job has resulted (most of the times) in errors that require extra work and more time invested than just...