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...

Dennis Jensen, your positivity is impressive and laudable. But the definition of insanity as "doing the same thing repeatedly and expecting a different outcome" (wrongly attributed to Einstein) is applicable...

Sorry, I can't help you with this question, but I do admire the accuracy of your approximation!

Thank you to Ken and pietlinden for your support.

Okay Phil Parkin criticizing a questioner is poor etiquete. Instead if you feel their question needed more information simply state that without being condescending....

My query finds Min and Max to determine Lag, but I need to find the lastest Shipdate date(max) and then previous shipdate to determine lag  --> remove the Min(shipdate).

I...