asp.net - How to delete old aspnet users with aspnet_Users_DeleteUser procedure? -

i using standard aspnet membership tables , i'm doing maintenance of our database. want remove users have not logged in year.

i know how call aspnet_users_deleteuser stored procedure in order delete single user, how can use delete users aspnet_users.lastactivitydate < '1/1/2015'?

i can write select statement out usernames delete, how can execute procedure on each of them?

this should trick...

declare @applicationname  nvarchar(256),         @username         nvarchar(256),         @tablestodeletefrom int = 15,          @numtablesdeletedfrom int  declare cur  cursor  select  aa.loweredapplicationname,         au.loweredusername    [dbo].[aspnet_users] au join    [dbo].[aspnet_applications] aa         on  au.applicationid = aa.applicationid   lastactivitydate < '1/1/2015'  open    cur  fetch   next    cur    @applicationname,         @username  while   @@fetch_status = 0 begin         exec    [dbo].[aspnet_users_deleteuser]                      @applicationname,                     @username,                     @tablestodeletefrom,                     @numtablesdeletedfrom out          fetch   next            cur            @applicationname,                 @username end  close   cur deallocate cur