It's hard to see from the data, but why wouldn't 'theDate' be the PK?

I'm sure this isn't helping either

REPLACE(REPLACE(fm.DestTable, 'Holding_', ''), 'HoldingTable_', '')

and this

AND

(

LTRIM(RTRIM(ISNULL(CAST(im.NewValue AS VARCHAR(MAX)), ''))) <> ''

AND im.NewValue IS NOT NULL

)

Have you tried creating/populating temp tables and then running smaller parts...

• This reply was modified 4 years, 4 months ago by  Mike01.

can you provide a little bigger sample of the XML and some DDL would help.  Also, can you provide the query you are running?  What does the execution plan say? ...

SQLCMD can be used as well

I see this error in the ConsoleLog

Message: ExternalRequest_post: 'IDataInitialize::GetDataSource failed'. The external request has completed.

I did notice that I'm using 32 bit dtexec on my machine and 64 bit on...

Yes, I have UserID and Password in the connection string.  I'm logging in as myself, so we have same permissions and I'm admin on the box.

I don't have the db installed, but wondering if you could use lag function to keep track of quantity on hand as you mark things ready to ship

Does the merge insert?   The update has additional criteria it is checking.  Also, Why are you using a cursor, this looks like a set based operation would work faster?  I'd...

Joe,

instead of employees, I'm wondering what your thoughts are around the Party model.  I know you get a lot of grief here, but this is a legitimate question.

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

As much as I love Excel, I'm not going to go through it to generate DDL and sample data.  Please provide both and we can help you.

https://www.thesaurus.com/browse/location

The DDL works, but the data doesn't.  also, what are you expecting as a result from the data you provided

The pictures are fine, but I'm not going to create DDL and sample data for you.  You don't need to provide the table with 800 columns, just a temp table...

it would be a lot easier if you supplied DDL, Sample Data and your expected results.  Screen shots help, but not in setting up the data