Database

Saxet wrote:

Can anyone explain this behavior?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Start Time:  2013-05-22 12:51:03.6580584
End Time:     2013-05-22 12:51:04.6876518

Saxet wrote:

It's better (1.0295934 seconds), but still slower than the select in the SSMS window.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

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

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