How To Do This In SQL Server Stored Procedure

Here is my problem:





I am designing Support System. I have a stored procedure for storing new Support Ticket. This stored procedure internally gets next ticket number and inserts Support Ticket








CREATE PROCEDURE [sp_SaveSupportTicket]


(


@pid int,


@uidGen int,


@status VarChar (100),


@probDes text,


@probSol text,


@guestName VarChar (100),


@os VarChar (100),


@roomNum VarChar (100)


)


AS


DECLARE @ticNum int


SELECT @ticNum = MAX(ticNum) + 1 FROM sup_TicDetails


INSERT INTO sup_TicDetails ( ticNum, pid, uidGen, status, probDes, probSol, guestName, os, roomNum,dateofsub)


VALUES (@ticNum, @pid, @uidGen, @status, @probDes, @probSol, @guestName, @os, @roomNum, CONVERT(VARCHAR,GETDATE(),101))


GO








Now... before this happens, on my ASP.NET Page I have a label Ticket# . This label displays next ticket number





CREATE PROCEDURE [sp_GetNextTicketNumber] AS


SELECT max (ticNum) + 1


FROM sup_TicDetails


GO








Now.. how can I have only 1 stored Procedure so that I can obtain next ticket number and display it on ASP.NET page and when I hit "Submit Ticket" sp_SaveSupportTicket gets executed ??





I hope I have made my problem clear !! If not let me know.......