Stored Procedures SQL Server -

i have created stored procedure lists customers have 7 days left on membership.

create proc spgetmemreminder     select users.fullname,            membership.expirydate       membership            inner join users              on membership.uid = users.uid      convert(varchar(10), expirydate, 105) =            convert(varchar(10), ( getdate() + 7 ), 105)  

i insert list table automatically. how achieve this? suggestions appreciated. thanks

what other suggestion is... don't write stored procedure insert temp table, because data changing.

just write view....... , have "report" use/consume view.

if exists (select * sysobjects      id = object_id('dbo.vwexpiringmemberships') , sysstat & 0xf = 2)     drop view dbo.vwexpiringmemberships  go   /* select * dbo.vwexpiringmemberships */  create view dbo.vwexpiringmemberships        select usr.fullname,            mem.expirydate       dbo.membership mem            inner join dbo.users usr              on mem.uid = usr.uid      convert(varchar(10), expirydate, 105) =            convert(varchar(10), ( getdate() + 7 ), 105)    go    grant  select ,  update ,  insert ,  delete  on  [dbo].[vwexpiringmemberships] public go