That could be easily fudged with a CASE around the selection of the Duration column. But I don't think that's the OP's intention.

So, George, you say this is a...

Glad it helped you out 😉

Hi Brett,

Seems you are slogging around and getting somewhere step by step. It would however be very useful if you were to post DDL for the tables involved, plus some...

Hi,

I'm not an SSIS expert, so I'd suggest reposting your question on the Integration Services forum which you can find under Data Warehousing on this site. I'm sure you'll have...

Looking (or rather guessing) at the problem statement, Wolfgang's query should do the right thing, but it wont give the right result for Alen since it will show 49 minutes...

Hehe, I beat you to it Tom 🙂

I'm guessing here because your requirements aren't quite clear. What you seem to want to do is to set the Type column to either 'OK' or 'NOTOK', based on whether...

Hi Denis,

First of all, it is always a good idea to post DDL (in other words scripts to put the table structures together) and a set of sample data (as...

... Maybe the absence of a right fielder in the lineup is a nod to the common perception of right field as a "throwaway" position that's not very important to...

Lynn Pettis (6/14/2013)

---

***************************************************

I am officially going to Afghanistan!

I leave for IRDO at Camp Atterbury in Indiana on Sunday, June 23rd. All should go well there with me leaving there...

dwain.c (6/13/2013)

---

Sean Lange (6/13/2013)

---

WayneS (6/13/2013)

---

dwain.c (6/12/2013)

---

I can only imagine what it must be like to have SQL Server running in some non-English language. MS probably translated the obtuse into...

The Dixie Flatline (6/13/2013)

---

A Dr. Who reference worked into a classic comedy routine by Abbott and Costello, Gail.

http://www.youtube.com/watch?v=J_gSWTQKE-0

Unfortunately, you have to know something about baseball to...

Lynn Pettis (6/13/2013)

---

SQLRNNR (6/13/2013)

---

Brandie Tarvin (6/13/2013)

---

jasona.work (6/13/2013)

---

Why can I picture something like that actually being buried in the depths of the SQL / SSIS code?

One of those little "bored programmer"...

No.

Please, remember this is an MS SQL forum. You better ask this question on a MySQL forum in order to...

wolfkillj (6/3/2013)

---

I heard a great joke for nerds (I was about to call it "nerd joke", but it's for nerds, not about nerds) this weekend:

Why do computer science majors always...