At a guess you have one too many single quotes (apostrophes) at the end of this line, i.e. four where it should have been only three:

SET @sqlZ = 'USE ['...

This query will only work if there is exactly one part.  I added one more record for a different part, and now I am getting no records at all.

Instead of using the apply approach you can also try a reworked query, which works wth the minimal test data you provided:

declare @v_po_history table (
  ...

• This reply was modified 3 years, 4 months ago by kaj. Reason: TYPO: prived --> provided

Okay, since we now have learned that you're using Pervasive SQL (BTrieve based) that changes things.

I don't know anything about...

I fully agree with the comments made by others, but if the OP would like to try anyway, this will work with the test data provided:

 select...

Something like this perhaps?

declare @v_po_history table (
    Part varchar(20),
    Lowest_Cost dec(9,6),
    Date_Received date
    )

insert into...

What is it you want to achieve?

PING is a tool that checks a connection to a destination server using ICMP packets. Many firewalls block ICMP from the internet by default.

https://en.wikipedia.org/wiki/Ping_(networking_utility)

But...

;WITH test_data AS (
    SELECT '100' AS Input UNION ALL
    SELECT '1.1' UNION ALL
    SELECT '1.10' UNION ALL
...

All true, but it's equally true that you can turn a cross join into what is in reallity an inner join by moving the ON join criteria of an INNER...

• This reply was modified 3 years, 5 months ago by kaj. Reason: Moved SQL into the correct format for readability purposes

The issue is that I need to select the MAX date when:

If the Max Date from my_column is equal to today's date, I need to select the Max Date...

Also worth mentioning is that you should (almost certainly) never use a DELETE on the whole table. TRUNCATE is much more efficient, and frees up the allocated resources + it...

I would check the system stored procedure, i.e. msdb.dbo.sp_send_dbmail, to see if the sp has been modified to append a fixed mail address to any list of email addresses passed...

I have to agree with Phil, your replies don't make much sense, and I am also on the verge of despair about you inablility to state your requirements in a...

Download NAD in csv format, import it into a table, then select random entries from there?

https://www.transportation.gov/gis/national-address-database/national-address-database-nad-disclaimer

You have to re-throw the error from the catch section of the inner sp, so that it may be caught by the calling outer sp.

https://docs.microsoft.com/en-us/sql/t-sql/language-elements/throw-transact-sql?view=sql-server-ver15