Thank you EdVassie. I still have a question though.

Taking your advice, went ahead and installed SQL Developer Ed., using the installation wizard to select only the Database...

Can anybody answer my question? Does the subquery for the IN return anything? What is its result set? Thanks.

I'm with you Bob. I still don't get the "point" of the query working this way for a subquery. So, from a logical perspective, what does the subquery...

Steve, don't quit your day job! Oh wait... that is your day job. :ermm:

but seriously, Thanks!

GilaMonster (12/29/2008)

joshcsmith13 (12/29/2008)

I definitely support Topics at the top level. I can't count the number of times I needed to post a T-SQL question, and couldn't decide if it should go...

Thanks for the article Leo. It seems well suited to function in the environment you propose. I want to know why I never see anybody use the...

hey bitbucket, you may be as shocked as I was to learn that this is not even a SQL2005 addition. It existed in 2000! It's always humbling to...

I think I agree with Jack. It's frustrating when I know the right answer(s), but get docked because of obscure semantics. REVERT and ending session will end the...

maybe I'm just dense, but I've reread the question 5 times, looked at the answers, and I still don't get what the "correct" answer was supposed to be. ??...

I like your solution. I had a similar problem and solved it a bit differently. I created a login to the server with permissions in msdb to execute...

I'm not sure where this falls in the Socialist vs. Capitalist argument, but did anybody read yesterday's feature articles???  Check out "Free Tools for the SQL Server DBA" http://www.sqlservercentral.com/columnists/dbird/2959.asp.  There's...

OK... so, I should replace my OLE DB Destination object with the OLE DB Command object to do the lookup and insert. ?  I'm trying to figure out why this ability has...