SQL Script - Finding Disconnection Date

This script is used for finding an account's disconnection date within Manitou.

SELECT transmitter_id, site_name, discontinued_date, last_event_date 
FROM ABMtransmitter 

WHERE (last_event_date <= "last_event_date")
	
IF NO DISCONTINUED TRANSMITTERS TO BE INCLUDED
AND current_status <> "disc"

IF ONLY DISCONTINUED TRANSMITTERS TO BE INCLUDED
AND current_status = "disc"

IF DEALER ENTERED
AND dealer IN (dealer_list)

IF SUBSCRIBER ENTERED
AND subscriber IN (subscriber_list)

IF ORGANIZATION ENTERED
AND organization IN (organization_list)

IF SITE ENTERED
AND site IN (site_list)

IF TRANSMITTER ENTERED
AND transmitter_id IN (transmitter_list)


 

Was this article helpful?
Thank you for your feedback!
User Icon

Thank you! Your comment has been submitted for approval.