Trigger Updating another table - Baseball Database
at first glance I found a couple of things that might give you issues


IF Strike = 1
BEGIN
    SET @Strikes = 1;
    SET @Balls = 0;
END
ELSE
BEGIN
    SET @Strikes = 0;
    SET @Balls = 1;
END



IIRC, you can perform 4 foul hits before you are considered "out", and that a foul hit on the first and second pitch are also counted as "Strikes" but not the third foul hit. going through this logic will give you a false "ball" count because it is a foul but not a strike.



I also noticed


IF Contact = 0
BEGIN
    SET @Contact = 1;
END
ELSE
BEGIN
    SET @Contact = 0;
END



I assumed that @Contact was your "hits" but I tried to go through the logic and I am a bit confused.  If Contact = 0 means to me that there wasn't a hit, but you set the variable to true (SET @Contact = 1;) 

Again IIRC, not every contact with the ball counts as a "hit"