Let me know if this code looks good, and we can convert it into more dynamic code.  I didn't want to spend time doing that until I had the core...

Heh... guess I'm more ancient.  I've not found much that will actually beat BCP for performance...

Could you please post directly usable data, i.e. CREATE TABLE and INSERT statements for the example table data.

You also might have a NULL value for po_num in preqitem.  That would prevent the NOT IN from yielding any results, so add a NOT NULL check.  Or, perhaps even...

Are you exporting the data to load into a different SQL Server instance?  If so, then you should "native" format on the output.  That will save a lot of time...

What we ultimately ended up doing was creating a separate db to store user tables in.  A view and/or a synonym can be used in other dbs to allow the...

I would expect that behavior honestly.  I don't see how SQL could realistically maintain a potentially almost unlimited number of intermediate row counts for different snapshot points for every table...

Expect to have to do lots of tweaking to the code to handle all the things that come up, though.

NULL / NOT NULL for each column (which should...

Expect to have to do lots of tweaking to the code to handle all the things that come up, though.

NULL / NOT NULL for each column (which should always be...

A proc is possible, but most people don't code an actual CREATE TABLE statement, they use the gui.  They would have to pass in a block of SQL, which means...

Probably the easiest work-around is likely a DDL trigger that prevents them from issuing any DROP TABLE (and ALTER TABLE on a table they didn't create, if you need that,...

You need to back up and actually do logical data modeling (Google "logical data modeling") not table modeling.  You literally cannot normalize what you posted because there are no usable...

• This reply was modified 6 years, 1 months ago by ScottPletcher.

Ok, interesting.  Can you give an example of code that is indefinitely executing?  Are you sure it is this sp_executesql code and not some other code in the proc?

[Yes, I...

2. ... [H]ow to address this problem ?

That depends on the specific details in this situation.

2A. How many rows are in the remote table?

2B. How much data do you need...

A basic numeric calculation should not take long to execute.  Look at the @ParmDefinition and make sure that it is not a calling stored procedure or doing something else that...