Please post the final solution so that the users who find this post on search engines may get an answer.

Is he talking about this?

Menu >> Query >> Include execution plan?

There's a lot more details than before (or at least more user friendly) but I wouldn't call that a new...

Great!  However if you ever need to have them in separated columns, then just use Chiraq solution and check out the pivot option in the books online.

Damn I need to get out more... DBA dream job hunt season officially opens next monday (contract to work on this week-end ). ...

Well I wasn't.  For the first 2 minutes I worked there .

Check the third post from this thread.  Just ask if you need help implemanting it :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=278637

Do you need that in seperate columns or single comma delimited column?

Ya I already implemented something like that.  It wasn't because of bad design but more because of user needs.  They needed to have a week displayed on a single row...

Nice, to know I'm not the only one in that situation .  Anyways, have a look at the exists part of the trigger with...

Greenhorn here wondering what is so bad about DTS????

Amen Sergiy!

However, if that can't be done like in my case where I had no control over the 3rd party application. He'll have a 2nd option to block updates...

I didn't mean that my solution didn't involve a trigger. What I meant is that the he needed more details to provide a solution.

Sorry for the loss of formatting, but this is what you need. The only modifications you'll have to bring to this code are the tablenames and the list of...

So Sergiy, how would one want to do this with DTS ???

.

Nice trick... but I assume that this column must be put at the end of the line to work?!?!