USP_RECORDOPERATION_BBAIMPORTFILES_CLEARALLPROMPT

                            create procedure dbo.USP_RECORDOPERATION_BBAIMPORTFILES_CLEARALLPROMPT (
                                @ID uniqueidentifier,
                                @ACTIVEFILES smallint output
                            )as
                                set nocount on;

                set @ACTIVEFILES = 0;

                          select 
                  @ACTIVEFILES = 
                            case when CONSTITUENTFILESTATUSCODE = 2 then 1 else 0 end
                            + case when SUGGESTEDMEMBERSHIPLEVELSFILESTATUSCODE = 2 then 1 else 0 end
                            + case when TARGETGIFTRANGESFILESTATUSCODE = 2 then 1 else 0 end
                            + case when WEALTHESTIMATORRATINGSFILESTATUSCODE = 2 then 1 else 0 end
                            + case when MODELINGANDPROPENSITYFILESTATUSCODE = 2 then 1 else 0 end
                          from dbo.BBAIMPORTFILES

                                return 0;