All pastes #479129 Raw Edit

joejoe

public sql v1 · immutable
·published 2007-05-09 15:43 UTC
rendered paste body
CREATE   PROCEDURE [dbo].[usp_GetSECUserRegistrations]ASSelect        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'GO