As you've posted in a SQL Server forum, are you looking for a T-SQL solution?

What does the package do?

Could there be a date format difference (eg, DMY vs MDY) between the two environments?

I will probably follow Jeff's advice not to use TempDB, even though I think I would still get to keep my job if I did. It would have had...

Duplicate key / constraint violation? As requested above, please provide the text of the error message.

Interesting. Perhaps more useful for beginners than seasoned professionals.

The following sentence is inaccurate:

 This code is using the GETDATE(); function which is not allowed in a stored procedure.

There is no problem...

Phil Parkin from what I gathered they did not care about the order just the first record that has Accepted or Rejected means that the RecordId gets a 1 otherwise...

As there are so few rows, I'd create a chunk of code which drops, creates and populates the table in TempDB

DROP TABLE If EXISTS #SomeLookup;

CREATE TABLE #SomeLookup(SomeKey...

In my sql result, I want to create a column called RCount. Condition: For each RecNo, AccNo * If the field Reason is "Accepted", it doesn't matter what other...

If I do any significant development work, I document it myself in Confluence. This documentation remains internal, but for me has the following benefits:

1. I can send links to people...

As the Ids are different, should the grouping be based on HorseName?

You have been here long enough to provide DDL, INSERT scripts etc and have chosen not to. My suggested...

Can't see why it's not working, based on the code you've provided.

Why are you doing this in the proc?

DECLARE @RECORD_ADD_DT datetime
SET @RECORD_ADD_DT = @RECORD_ADD_DATE

Seems pointless – just...

This returns your desired results, but is it what you want?

DECLARE @SQL1 NVARCHAR(MAX)
    = N'SELECT ri.Serial_Number
      ,UnitType = ri.Part_Number
...

Good answer, makes complete sense, thanks for taking the time to write it out.

There are a couple of points I'd like to mention, however.

First is that SFTP is completely doable...

Taking a step back for a moment ...

It seems that you are running an SSIS package which calls a proc which runs BULK INSERT – a rather convoluted design. May...

Standard forum etiquette is to leave your question unedited and to post the solution you found, for a couple of reasons:

1. It may help others with similar requirements
2. People here...