That's fine. I'm not doing this for instant recognition.  This is just my way of helping out writing articles for important topics that no one got around to write.

Jacob may not have seen your reply.  Here's what you need (all credit to him for doing the heavy lifting):

SELECT t2.[id],
   t2.[Brand],
   t2.[condition]

It doesn't appear this has been covered by an article.  I just finished my latest submission and don't mind going after some low-hanging fruit to help clean out the queue.

I have submitted my draft for this.  Thanks for letting me take a stab at this.

I can handle this if you're still looking for a comprehensive write-up.

If you deploy your SSIS package to a SQL Server environment and then set up a SQL job to execute the package, you can create a batch file to run...

Thanks for the opportunity.  I've submitted my draft for review.

If you're still looking for articles for this topic, I'd like to take a stab at it.  Can you assign this to me?

Here ya go.  This gives you the intended results.  I have commented the code but please let me know if you have any additional questions

DROP...