Directly from Microsoft:

MULTIPLEXING: USE OF MIDDLEWARE, TRANSACTION SERVERS, AND MULTITIERED ARCHITECTURES

Sometimes organizations develop network scenarios that use various forms of hardware and/or software that reduce the number of devices or...

Unfortunately, no. You need a license for each user that accesses the database through the web site. In this case, you really need the per processor license for...

Even the routine selects should be filtered on the server to reduce the amount of data crossing the network.

I understand about time/political under currents. That was part of the...

How is a variable going to retain the last value from the previous run? You have to establish a process that ensures you get the next proper file name.

I...

Off hand, not really. I'd use the connection manager to name the file with a base name, then use a FileSystem task to complete the actual rename of the...

In your Flat File connection manager for the output file just be sure that the Column names in the first data row is unchecked.

😎

Sorry, it wont as written. You will have to modify the code as I wrote it for SQL Server 2005. You will have turn the CTE into a...

Based on the article Jack referenced, here is some sample code for you to start with:

create table #TempTable (

RefOne int,

RefTwo int,

...

Colin Betteley (10/22/2008)

I have a table as follows.

RefOne RefTwo Item Purpose

100 ...

Just to be sure I read your original post correctly. Users have a local copy of Access on thier desktop systems and are linking tables in this local Access...

Definitely like Ken's way of doing it. No loops or calculations required.

😎

Yes, it does. You can use it to create a Data Model.

😎

Check out Enterprise Architect. The reason I purchased it...

I use ERStudio here at work, but at home I have Enterprise Architect from Sparx Systems.

😎

You have to upgrade the CAL's as well.

😎