Is there a way to have multiple error messages displayed with RAISERROR conditionally? I am thinking of something like the CASE statement for RAISERROR, but I want the remaining code to be checked too, and not skip anything after encountering the first RAISERROR. Right now I have something like this. 



Now, I want a way where I can RAISERROR at the very end and do it conditionally. So if there are two errors from three checks, both should be displayed to the user. Thank you.
One method is to build an error message string and issue a single RAISERROR conditionally after all validations are done.

DECLARE @ErrorMessage varchar(2047);
IF @ForeCastYearCheck = 'false'
    SET @ErrorMessage = @ForeCastYearCheckError;
IF @ForeCastQuarterCheck = 'false'
    SET @ErrorMessage = COALESCE(@ErrorMessage + ',' + @ForeCastQuarterCheckError, @ForeCastQuarterCheckError);
IF @ForeCastComboCheck = 'false'
    SET @ErrorMessage = COALESCE(@ErrorMessage + ',' + @ForeCastComboCheckError, @ForeCastComboCheckError);
IF @ErrorMessage IS NOT NULL
    RAISERROR(@ErrorMessage, 16, 1);