You can always change your default database to one you use the most...

USE Test

GO

INSERT INTO Practice

select 'John', 'Jones', '99980', '45', 'Payson', 'Arizona'

union all

select 'Mary','Jones','99982','25','Payson','Arizona'

union all

select 'Eric','Edwards','88232','32','San Diego','California'

Cheers,

K

J,

See if this does the trick...or maybe at least help you in the right direction, if I messed up the logic somewhere...

Left joining to table B and then eliminating...

Another way is to:

In management Studio...Right Click on the tablename...go to ViewDependencies.

That should give you objects dependant on that table, and object that table depends on.

K

If I understood you right...could you join to the same table a multiple times to get the different information...something like this...

You would join to the Fees table on the client,...

It seems from the error that it is still expecting that space in the name of the last column (there is a space in the error between the name and...

If you are running your package in visiual studio, after you execute it, there should now be a "Execution Results" tab next to all the other tabs (Control flow, data...

Do you have all the correct permissions on the table? You may be able to view it but not actually select from it...

Could you just generate the 'Create' scripts, and then do a find replace of 'Create' with 'Alter'...

You can either add a SQL statement at the end of the Procedure to allow the user Exec Permissions.

Grant EXECUTE ON [ProcName] TO [UserName];

or

in Management Studio, right click on...

Seeing the Same issue...have been trying to figure out for a little while now...If somebody knows of a solution please respond.