I think your example isn't good, but it looks like you're looking for the first N for each code and then report all Y until you get to the next...

I would start with the cursor.  Have you narrowed down which part is taking the longest? You can probably remove the cursor and do a set based operation and output...

if there are more than 2 periods, then this will need to be modified to handle that part.  I changed tablename to #mytable

drop table if...

I'm not sure why you would need these, but you can try this.  Also, I out in a case for null, but not sure that will ever be used

Some DDL and sample data would be helpful as well as expected outcome, not what you are currently getting

First you need to understand what the db2 trigger is doing.  It looks like it is using the timestamp data type (or rowversion) and checking the upper limits of it. ...

not in my case.  These are being passed into a proc and the proc is returning Vendors that match the VendorNum or VendorName, order doesn't matter

It always helps to have data. I think this is what you are looking for, but you're question is not very clear and you don't specify any expected results in...

Just to close the loop.... I wasn't worried about order.  I just needed to get it in key/value pairs, so I could use it as a lookup.  Thanks for all...

As long as the priority is by Inv_Item_ID

IF OBJECT_ID('tempdb..#Vendor') IS NOT NULL
    BEGIN
        DROP TABLE #Vendor
    END
go
IF OBJECT_ID('tempdb..#Vendor_UOM') IS...

ok, I think I have what you need.  I changed the names of the columns so the ordering would be correct (I used YYYY-MMMonthName instead of MMMonthName-YYYY).  I also used...

Wow, that's a lot of code 🙂  I'm having trouble trying to find out where the data is coming from in the #CorrectResponse table.  Can you provide what the values...

Thanks Scott, but that's not what I was looking for.  I was essentially looking for Key Value pairs and using the node as the column name.  So it would look...

Removed!!!

Steve beat me to it, and surprisingly similar code