Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  stored procedure question

Author  Topic  ajay Starting Member 34 Posts Posted - 2001-05-15 : 08:10:49 Hello sql, Table structure is like this id->identity article->varchar article_entry_date-->datetime default=getdate() The question is, I have to make an stored procedure which will give me no. of new records added every time I run the procedure. for e.g. lets say till yesterday there were only 10 records and day before yesterday there were only five. My procedure will run every morning to check the no of new records added and based on that I will write a programme which will send mail to different people. Can any one please guide me as to how to accomplish this. thanks for the help! truly ajay