set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgo-- =============================================-- Author: Kenroy Bennett-- Create date: 15 December 2006-- Description: Get Messages for a specific period-- =============================================ALTER PROCEDURE [dbo].[GetMessagefromDate] -- Add the parameters for the stored procedure here @start_date datetime =null , @end_date datetime =nullASBEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; if @start_date =null or @end_date=null @start_date=GetDate() @end_date=GetDate() -- Insert statements for procedure here SELECT Date,Source_no,Destination_no,SMSMessage from Messages where Date between @start_date and @end_date order by Date descEND