Unpivot doesn't work, because you have two series of columns, which should be unpivoted.

The following isn't nice, but it should do.

create table #tmp(

ID int

...

Select

Sum(

case

when col10

then col1

else 0

end

) as [col1+ve],

Sum(

case

when col20

then col2

else 0

end

) as [col2+ve]

from giventable

Age2uN

Are you trying to import from an Excelfile here, which you had locally on your machine ?

If so, check the path to that filegiven on the package.

Maybe it points to...

Identity columns in TempTables or MemoryTables work as expected:

either :

Create Table #myTempTable(

RowID int identity(1,1),

otherRowsFollow nvarchar(100)

)

or:

Select

Identity(int,1,1) as RowID,

...

AND (@ProvTaxIdNbr IS NULL

...

Something along this line :

SELECT

t.LAST_NAME,

t.ID_SET_STATUS_TYPE AS STATUS_CODE,

t.STATUS_CODE_DATE AS START_DATE,

(

...

Limiting the Max-Memory for SQL Server to physical memory of the box minus 1.7 GB has proven

quite a good value whenever there are other apps running on the same...

Another best practice in doing frequent imports of that data-size is:

First check what targetrows have to be changed or have to be inserted

(push them into a worktable via

select...

Sounds to me as if there is a trigger on the updated table firing some other action per updated row.

This might as well slow down everything trmendously.

Given your amount-bearing table is "position" and the column name holding the amount in $ is "salesamount",

and given your currency table is "currency" having a column "shortcut" holding the value...

in window "new job schedule"

select schedule type = "start whenever the cpu becomes idle"

First of all : Shorten your transactions.

If your client opens a connection,

reads some data ie that connection,

waits for the user to enter changes or new records,

writes back the data...

What's your JOB going to do ?

Does it poll for something to do, and if there is, do it.

Or

Does it produce continuos load...

This probably has to do with the boxes taking part in the transaction.

If you start the DML via SSMS on box1, it is only the three boxes box1, box2 and...