Restrict User Registrations to 10 for each day using SQL Query

Hi parthiban,

Please create your SP as below pass parameter of your interest and Insert in appropriate tables as where I commeted to do so.

CREATE PROCEDURE RegisterUser
-- ADD YOUR INPUT PARAMETERS HERE
AS
BEGIN
	SET NOCOUNT ON;
	IF ((select count(id) from joinees
		where year(regdate) = year(getdate())
		and month(regdate) = month(getdate())
		and day(regdate) = day(getdate())	
		) < 20 )
	BEGIN	
		-- DO YOUR CODE HERE
	END	
END
GO

And for How to use the SP please follow the following links...,

1. Insert data Using SP.

2. Insert data Using SP And return Last records ID

Thanks and Regards,

Rk_Hirpara.