spGet_ATHLETICS_LOCATIONS

CREATE PROCEDURE [dbo].[spGet_ATHLETICS_LOCATIONS]
    @ID int = null,
    @ClientSitesID int
AS
SET NOCOUNT ON

if @ID <= 0
    SET @ID = null;

SELECT al.[ID], 
    al.[Name], 
    al.[Description],
    al.[ContactInfoID],
    al.[IsHome],
    ac.Phone,
    ac.Email,
    ac.Address,
    ac.ContactName,
    case when 
        exists(select * from dbo.ATHLETICS_EVENTS ev where ev.LocationID = al.ID) then 0
        else -1
    end as 'CanDelete'
FROM dbo.ATHLETICS_LOCATIONS al
LEFT OUTER JOIN dbo.ATHLETICS_CONTACTINFO ac
ON al.ContactInfoID = ac.ID
WHERE al.[ID] = ISNULL(@ID, al.ID)
and al.ClientSitesID = @ClientSitesID
ORDER BY al.[Name], al.[Description]