joejoe

CREATE   PROCEDURE [dbo].[usp_GetSECUserRegistrations](	@Date1 datetime,	@Date2 datetime)	ASSelect 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 @Date2GO