set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

-- =============================================
-- 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 = null
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
	if @start_date is null or @end_date is 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 desc
END