CREATE PROCEDURE ap_GetNextProjectNoForClient @CustomerCode VARCHAR(03), @NewCustCode VARCHAR(07) OUTPUT AS BEGIN DECLARE @Count INT SELECT @Count = COUNT(CustomerCode) FROM COSProjects WHERE CustomerCode = @CustomerCode SET @NewCustCode = @CustomerCode + '-' + dbo.PADL(@Count, 3, '0')I'm calling it like this:
DECLARE @Code VARCHAR(3) EXEC ap_GetNextProjectNoForClient 'MCD', @Code OUTPUT SELECT @CodeAll I'm getting back is the @CustomerCode value.
SELECT @CustomerCode + '-' + dbo.PADL(@Count, 3, '0')