If you create your staging table with an identity column, you can do something like this:

INSERT INTO Table1 (colA, colB, colC,...)

SELECT (colA, colB, colC,...)

FROM MyStagingTable

WHERE IDCol <= 500

INSERT INTO Table2...

I don't know, because you haven't said on what criteria the record set will be split. There are transformations you may be able to use, such as the Conditional...

Import all the records into a staging table, then use whatever logic is necessary to move the first 500 records to one table and the rest to the other.

John

What goes into the parentheses at the end of the INSERT line is a list of the columns into which the rows will be inserted. If the columns in...

SELECT INTO creates a new table. If you want to insert into an existing table, do it like this:

INSERT INTO Table1 (ColA, ColB, ...)

SELECT ColA, ColB, ...

FROM Table2

John

Two things you might consider are converting your scalar-value "Get" functions to table-value functions, and omitting the ORDER BY and having your presentation layer do the sorting instead.

John

Each node is a "box", so for a two-node...

Dev (11/11/2011)

---

Well I can understand the scenario & your worries / frustration as well. I have experienced it. I don’t remember exact code that caused the issue BUT...

The error message tells you what you need to know. You can't use the same physical files for a different database. You have to specify new files.

John

Lee

(1) http://www.sqlservercentral.com/articles/Administration/2960/

(2) That's the Windows version.

John

Never code an application so that a transaction waits for user input. You'll have too many locking issues when users forget to complete their work before they go off...

If you're just executing a simple insert, why do you need an explicit transaction? If you want to do it like this, I think you'll need something in your...

You could try searching for "gaps and islands" - this looks like a similar principle to that.

John

Instead of GETDATE()-1, try DATEADD("Day",-1,GETDATE()).

John

So you want the date in the file name always to be yesterday's date? Best way to do that is to do some date arithmetic and take one day...