Interesting. Clearly I need to study up on FOR XML PATH. Thanks, I'll continue to review.

The issue sounds like the plan rather than the job. I would drop the plan and recreate, if its fairly standard you should be able to run the wizard. Or...

I'm faced with dozens of deployed packages that do not have logging enabled. So this would replace the need to modify lots of packages.

So I realize that accepted best practice...

This thread looks promising as a solution....

http://social.msdn.microsoft.com/Forums/en-AU/transactsql/thread/ec9348c5-acbc-4ca7-8793-322847511460

http://msdn.microsoft.com/en-us/library/ms186238.aspx

Interesting dwain.c, thanks for the link.

Mr. Celko inspired my design choice based on previous post so I have come full circle.

That would certainly simplify table design and integrity enforcement with a slight increase in querying complexity. I'll look at my data model and evaluate the cost of changing this.

I still...

http://msdn.microsoft.com/en-us/library/cc768544%28v=sql.100%29.aspx

I would also like to identify which record is which, the top or the bottom.

'bottom' 1 21 7

'top' 1,21, 9

'bottom' 3 29 13

'top' 3 29 15

'top' 4 55 27

'bottom' 4...

What do you mean by random? We could have a huge philosophical discussion about what that means....

Can you order the projects by ID and take the highest value? Or lowest?...

Thanks. The following worked for me in the image expression..

="/Images/logo.png"

TRUNCATE can actually be rolled back. See my recent thread here:

http://www.sqlservercentral.com/Forums/Topic1361513-1292-1.aspx

Yes, exactly, thank you once again.

This should get you started as far as SSIS.

http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/70011/

Options you may want to explore.

http://technet.microsoft.com/en-us/library/ms153697%28v=sql.105%29.aspx

I ended up using a Months table, see below. This seems to simplify the analysis greatly.

Question: Is it appropriate to index every column in a calendar table like this that...