>CREATE PROCEDURE PTP_GetModCount >@Filekey as varchar(20) >AS >declare @OnlCnt as int >declare @OffCnt as int >I'm guessing there is more to the sproc than you are listing here? You are declaring @OnlCnt and @OffCnt as local variables, so you don't need to pass them as parameters.