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.

;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 2 years 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

How about this?

select distinct p.*
from #proposal p
cross apply (
    select top(1) proposal_id
    from #proposal op
    where (op.change_ref =...

Btw, the same can be achieved by utilizing TOP's big brother, the FETCH filtering:

WITH LastTwoDates AS (
    SELECT DISTINCT 
    ...

• This reply was modified 2 years, 2 months ago by  kaj. Reason: TYPO: eliminame --> eliminate

A slightly different approach:

WITH LastTwoDates AS (
    SELECT DISTINCT TOP(2) 
        LOGDATE 
    FROM...

Maybe something like this?

WITH SinglesourcePartCompany AS (
    SELECT GivenPartNumber_Non,  vcompanyid
    FROM #notmappedsources
    GROUP BY GivenPartNumber_Non,  vcompanyid
...

Okay, based on your query and your query output I have tried to guess some of your data and created some test tables (I have used declared table variables):

This reply was modified 2 years, 2 months ago by  kaj. Reason: Added column to join criteria for table medicalcode, and added comment about the additional table used