(no subject)

USE life
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'daily_update' AND type = 'P')
      DROP PROCEDURE daily_update
GO
CREATE PROCEDURE daily_update
AS
SELECT content, date
FROM dbo.daily_life a join dbo.journal b
on date.a = date.b
UPDATE life.dbo.journal_entry
set daily_content = 'standard daily bullshit of no particular importance'
where
@content = NULL
GO

EXEC daily_update

Yeah, nothing in particular to report. You're getting an entry anyway. Get used to it if you're not already. You're still here, so i'd assume you are.