Something like this maybe?

;with cte

as

(

select IndName

, Account

, AddresType

, AddressLine1

, AddressLine2

, City

, ST

, ROW_NUMBER() over (partition by AddressType order by (case when AddressType = 'Main' then 1 when AddressType...

You should be able to OUTPUT to another table as long as it's on the remote server as well, because the OUTPUT sees that table as local.

You don't as far as I know. You just let it go dead.

Glad to hear you found a solution.

It's exactly the same code, variables included. Part of what's missing is that there is a cartesian product in the code. Basically one of those..."let's look at a million rows...

Output it to a local table with and move it from there?

You don't actually pass them to the SSIS packet from outside. You have the SSIS packet pull the information from those table from inside the package itself. You can use...

What I've done in the past is used a table to read the filenames and paths that I wanted to import and then used that table/column combination to assign variables...

Contact your System Admin. When you use the RDP you're on the native client and have different permissions from when you access remotely. That would be my guess as I...

Have you tried adding a blank character in front of your PO field during the query? ie. ' '

Generally Excel will consider that a string and left-align it.

Possibly if you compare the created date to the last modified date you can use that as a guideline. Any job that has a different last modified date to its...

The owner_sid column will give you information regarding who owns the jobs. Just exclude anything owned by the system. That will help for any jobs that people haven't reassigned to...

That was my initial thought but the OPs post seemed to imply that it would be frowned upon by the Establishment

Greg Larsen has an excellent article about query metrics here:

http://www.sql-server-performance.com/2008/Query-Execution-Statistics/

Dump the three tables to a csv and import them back into your dev server?

What exactly are you trying to improve? Reads? Writes? Can we get some stats on what you're trying to do?