spDelete_DataSource

    CREATE PROCEDURE [dbo].[spDelete_DataSource]
@PKID int

as

IF NOT EXISTS(SELECT NULL FROM EmailTemplate WHERE DataSourceID = @PKID)
BEGIN
    DELETE DataSources
    WHERE DataSourceID = @PKID
END
ELSE
BEGIN
    IF NOT EXISTS(SELECT NULL FROM EmailTemplate WHERE DataSourceID = @PKID AND Deleted = 0)
        BEGIN
            UPDATE DataSources
            SET Deleted = 1
            WHERE DataSourceID = @PKID
        END
    ELSE
        RAISERROR('Unable to delete DataSource - It is in use by one or more templates.',16,1)
END