I've never posted a problem because I have been too intimidated so this was a wonderful 'how-to'. Thanks.

WOW, I feel like I am in an other world bubble. I have been in the field for 20+ years from a young woman to a mother with 4 children...

My suggestion is to make them sign up for the SQLServerCentral daily letter. I came from an Oracle background, no ETL at all and no one to mentor me. Now I have...

Thank you Matthew, your comments about correlated subqueries were also helpful, I had added just that type of subquery to a procedure and watched it almost grind to a halt....

Thanks so much! I like derived tables also so it's nice to know they are efficient also. 

It was helpful, thank you. I am wondering about your comments at the end of the article. I think the derived table is easier to understand but did you mean...

I got totally confused because the pictures didn't match the text but I'm new enough to DTS I thought the explanation was too confusing not that the pics didn't apply. ...