Stored Procedures SQL Server

[damokk]

I have created a stored procedure which lists all customers that have 7 days left on their membership. ---------- create proc spGetMemReminder as select users.fullname, membership.expiryDate from membership inner join users on membership.uid=users.uid where convert(varchar(10), expiryDate,105) = convert(varchar(10), (getdate() +7), 105) ------- I would like to insert this list into another table automatically. How do I achieve this? any suggestions appreciated. Thanks

[scottgp]

Do you mean like this - http://sqlserverplanet.com/tsql/insert-stored-procedure-results-into-table[^]? Scott

[Corporal Agarn]

Just use an insert:

CREATE PROCEDURE spGetMemReminder
AS
INSERT INTO YourTableNameHere (FullName, ExpiryDate)
SELECT users.fullname, membership.expiryDate from membership
inner join users on membership.uid=users.uid
where expiryDate = CAST(DATEADD(day, 7, getdate()) AS DATE

if expiryDate is a date column it is better to do date compare than to convert both sides.

[Mycroft Holmes]

Use an insert statement, that is not why I am posting a reply. There are many ways to compare dates, comparing string (varchar) is probably the worst possible method. Do some research into the datetime object, you could have used datediff or dateadd neither of which require a convert. Never underestimate the power of human stupidity RAH

[damokk]

thanks!

[damokk]

ok will do. thanks!

[Arun Vasu]

Hai.... You can do it by table varible. create proc

spGetMemReminder
as
select users.fullname, membership.expiryDate from membership
inner join users on membership.uid=users.uid
where convert(varchar(10), expiryDate,105) = convert(varchar(10), (getdate() +7), 105)
end

GO

CREATE PROCEDURE InsertMember
AS
BEGIN
SET NOCOUNT ON
DECLARE @TABLE TABLE(fullname nvarchar(10), expiryDate datetime)

    insert into @TABLE
    exec spGetMemReminder

    insert into yourothertable
    select \* from @TABLE
SET NOCOUNT OFF

END

[Aatif Ali from Bangalore]

I think 'Insert into' query will help you