stored procedures in sql server 2008

Question

Hi... pls help me 

thanks for advance

my requirementi is 

 

table--->subcomment

Field--->Followupdate

Output-->Sms

-------------

step1: check in subcomment table,whether any of the FollowupDate(column name) is today date

step:2 If it is todays date,check whether time is exactly less than 60mins of current time

step:3 if step2 is true, fetch the subid,followupdate,comments and find the createdby by using join of dcrno in subcriber table and subid in subcomment table

step:4

Find the phone num of this 'createdby' user in Employee table +Login User Table

step:5

send sms to this phoneno with details like

custname,ph,subid-->subscriberdetails

followdate ,comments--->subcomment