set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[Nop_OrderLoadByCustomerID]
(
@CustomerID int
)
AS
BEGIN
SET NOCOUNT ON
SELECT
*
FROM [Nop_Order] WITH (NOLOCK)
WHERE
CustomerID=@CustomerID and Deleted=0
ORDER BY CreatedOn desc
END