What is the SQL query to find all deleted HEATBoard issues

Version 1

    Details

    What would the SQL query be to find all deleted HEATBoard Issues?


    Resolution

     

    This will give you the LeadCall ID also if it exists:


    SELECT SGName 'Issue ID', SGSFolder 'Lead CallID', SGDetail 'Details'

    FROM HEATSGen

    WHERE SGCode = 'HD'