spGetECardByKey

                create procedure dbo.spGetECardByKey (@ViewKey uniqueidentifier) as
                    set nocount on;

                    update dbo.ECard set DateAccessed = getutcdate() where ViewKey = @ViewKey;

                    select 
                        ID,
                        ClientSitesID,
                        ViewKey,
                        EmailSubject,
                        Html
                    from dbo.ECard
                    where ViewKey = @ViewKey;