Tech
Forums
Jobs
Books
Events
Live
Interviews Prep
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
0
Reply
stored procedures in sql server 2008
parvathi devi
Feb 8 2013 12:54 AM
963
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
0
)
Next Recommended Forum
how to use function in sql server with simple example
How i pass multiple values into the where condition column ?