CREATE PROC [dbo].[sp_InvoiceListingByDate]
(
	@DateFrom DATETIME
	,@DateTo DATETIME
)
AS

SELECT	*
FROM	pal_vInvoiceListing I
WHERE	LEFT(CONVERT(VARCHAR(50), I.InvoicedDateTime, 120) , 10) 
	BETWEEN LEFT(CONVERT(VARCHAR(50), @DateFrom, 120) , 10) AND LEFT(CONVERT(VARCHAR(50), @DateTo, 120) , 10)
ORDER BY I.InvoicedDateTime
GO


