CREATE   PROCEDURE [dbo].[usp_GetSECUserRegistrations]
(
	@Date1 datetime,
	@Date2 datetime
)
	
AS

Select FirstName,
       LastName,
       Company,
       UserStatus,
       CONVERT(CHAR(10),Registered, 110)Registered,
       a.UserID_Pk,
       Username,
       UserStatusID_FK
 FROM  sec_user a,
       sec_userproperties b,
       sec_userstatus c
 WHERE a.userid_pk = b.userid_pk
   AND a.userstatusid_fk = c.userstatusid_pk
   AND a.UserStatusID_FK = '3'
   AND a.Registered BETWEEN @Date1 AND @Date2
GO