Try rebuilding the clustered index on Table1 and updating statistics. You'll probably get 50/50 then. The index on Table1 is fragmented since you inserted the data after creating...

Check this out. You can then use the variable to set the ConnectionString property of your connection...

http://msdn.microsoft.com/en-us/library/ms188283(v=sql.100).aspx

One configuration option is to use a parent package variable in each of the packages that is called from your master package.

John

Craig

Here's two possibilities:

(1) Your account has a different default schema from the SQL Server Agent account

(2) The environment settings are different when it runs as a job, for example SET...

The actual same filegroup? No, it's not. A filegroup with the same name? Yes, it is.

John

On re-reading, I'm not sure that's what he's asking, anyway. Does he want to know how to have the folders automatically expanded when SSMS opens?

John

This doesn't make sense. Your INSERT statement doesn't fit with the definition for the onward_journey table.

John

You will be only be able to see objects you have any permissions on. Ask your administrator to grant you the permissions that you need.

John

I'm afraid it doesn't. It's much easier to understand actual data than an abstract description of it. Please have a read of this[/url].

John

Yes, you would. DISTINCT returns a unique set of rows across the whole column list. You could use GROUP BY if you wanted uniqueness across a subset of...

Let me rephrase my question. Please will you post a sample result set from your original query, and then show us how you want it to look instead.

John

If you want to remove the duplicates only from StackID, which values of Location, Move Date and Move Time will you choose for each value of StackID?

John

I'm not sure what you mean, but have you tried the INFORMATION_SCHEMA.COLUMNS view?

John

This will do it:

SELECT 2 AS region

UNION ALL SELECT 3

If that's not what you're looking for, please read this[/url].

John