ALTER PROCEDURE [dbo].[SP_GENERATETICKET]
@RESULT AS VARCHAR(255) OUTPUT
AS
BEGIN
DECLARE @D AS DATETIME = GETDATE()
DECLARE @LASTTICKET AS VARCHAR(50) ;
DECLARE @NUM AS VARCHAR(50);
SET @LASTTICKET=(SELECT TOP 1 TICKETNO FROM tblTicket WHERE
MONTH(ENTRYVEHICLE  ) = MONTH(@D ) ORDER BY TICKETNO DESC);
IF (CONVERT(VARCHAR(10),YEAR(@D),110) <> CONVERT(VARCHAR(10),YEAR(GETDATE()),110))--IF YEAR IS DIFFERENT, RESET SERIES
    BEGIN
        SET @NUM = '1'
    END
ELSE
    BEGIN
        IF ISNULL(@LASTTICKET,'1')  = '1'--IF MONTH IS DIFFERENT, RESET SERIES
            BEGIN
                SET @NUM ='1'
            END
        ELSE
        BEGIN
                SET @NUM = CAST(CAST (RIGHT(@LASTTICKET,5) AS INT) + 1 AS VARCHAR)
        END
    END

SET @RESULT = RIGHT(CONVERT(VARCHAR(10),@D,101),2) + '-' + LEFT(CONVERT(VARCHAR(10),@D,101),2) + '-' + RIGHT('0000'+CAST(@NUM AS VARCHAR),5)
SELECT @RESULT
END

SqlConnection con = new SqlConnection(gsql.connectionString);
SqlCommand command = new SqlCommand("SP_GENERATETICKET", con);

try
{
    con.Open();
    command.CommandType = CommandType.StoredProcedure;

    SqlParameter result = command.Parameters.Add("@RESULT", SqlDbType.VarChar);
    result.Direction = ParameterDirection.Output;

    txtTicket.Text = (string)command.Parameters["@RESULT"].Value;
}
    catch(Exception ex)
{
    MessageBox.Show(ex.Message);
}