ahh ok...you know your data better than us, of course...so if you have 400 identical tables, one for each client, that makes sense.

it's fairly easy to generate a script to add a column to every table in the database.

--company and will have a default value of FPO

SELECT

'ALTER TABLE ' +...

you can add favourodily25 to the list of spam accounts; i just re-enabled PM's from t= he forum, and got a couple from that log in.

glad i could help;

that one section of the case statements i just wasn't sure about...you obviously know your data better than anyone, it just seemed like it might be a...

to do this FROM SQLExpress, the table you are going to import into must already exist.

in that case, you can add a linked server on the SQL Express to Oracle,...

wow;

your issue seems to be you haven't recognized you can get all the values in a single select statement; there was no reason(or logic) to try to get each value...

sidenote to get a count much faster than select count(*) :

DBCC UPDATEUSAGE (0) WITH COUNT_ROWS, NO_INFOMSGS

SELECT OBJECT_NAME(ID) AS TableName, [Rows]

FROM dbo.SysIndexes

WHERE...

from what i read here:http://www.oracle-base.com/articles/8i/TemporaryTables.php

an oracle global temporary table seems to be the same as a regualr sql temp table...it is created for the user who connected, is not accessible...

well first, why a global temp table if you want to select justthe stuff your user inserted? why would a private temp table not do the trick?

but to answer your...

I've done something similar in my own stored proc; give it a test drive, I use it for some different processes for auditing and stuff; just a handy way to...

two links in my signature for CREATE TABLE and INSERT INTO will do exactly what you want, but in TSQL vs an external process:

sp_GetDDL takes a tablename, or optionally schema.tablename,...

since you need to know the values to pivot in order to pivot, you can't do it dynamically, but you can alias the values.

but you can certainly alias them like...

well, the quick and easy fix would be to alias from the final select instead of using select *

SELECT

CODE_GESTIONNAIRE

[20100009] As S_20100009,

[210100010]...

i thought the dependancy issue was only (potentially) inaccurate only...

here's a do it yourself way.

it just a cursor that goes thru the results of a temp table populated by the procedure sp_msdependencies

maybe this will help:

SET NOCOUNT...