I assume you're referring to more that just a mail merge data set.

If you know how to code in VBA, then Open your Word doc, hit Alt+F11 to open the...

Ahh... poetic justice... that the attorneys are drowning in the very flood of data that our onerous legal / regulatory environment has created.

On the tech side -

We have looked...

I already tried that but it also failed.  In the Derived Column transform, even though the commands appear to be SQL, apparently they are not.  I have found that string values must...

We are implementing a new Trust Accounting system that uses Cache.  I have not as yet worked with it, and from some preliminary discussions, probably won't.  Apparently it's based upon...

Also, this way from BOL:

SET CONCAT_NULL_YIELDS_NULL

Controls whether or not concatenation results are treated as null or empty string values.

Syntax

SET CONCAT_NULL_YIELDS_NULL { ON | OFF }

Remarks

When SET CONCAT_NULL_YIELDS_NULL is...

Also, in MS Access you can use a Saved Query just as you would use a Table.

So create your Query 1 and save it.  Then design Query 2 and select...

I recently read somewhere that if your DB is used primarily for analysis and reporting and you frequently have to join more than 4 tables, then you should consider denormalization...

If you mean to permanently change the values in the db table then use an UPDATE statement.

UPDATE My_Table

SET show_name =  'My hunter''s notebook'

WHERE show_name =  'My hunter''s journal'

I have never encountered default jobs in the 15 SQL servers I tend to.... don't believe there is such a thing.

Perhaps they configured those backups for you, especially if it's...

Yes, because the mycolumn value inside of the STUFF function will change with each row.  Why don't you test it as follows:

1) Run it on a copy of mytable

OR

Add a...

I'm not sure I can help you with the past accesses, but going forward, you may want to look into the SQL Profiler tool that comes with MS SQL and...

Perhaps I'm not understanding the question... but, if you execute the UPDATE statement without a WHERE clause, it will update mycolumn and reformat the date for all of the records...

You can also save the DTS as a Visual Basic file and include it in a VB program.

If you schedule by right clicking the DTS Package you will always get the encrypted DTSRun command line.

However if you use the dtsrunui.exe tool in C:\Program Files\Microsoft SQL Server\80\Tools\Binn

Select the...

I will generally use the Linked Server method for data links that tend to be more permanent.  For the one time scenarios I usually use MS Access and either link...