apna taste testing queries

apna taste test queies.sql

select * from orders

select * from orders ORDER BY id DESC

order summary dynamic query procedure.sql

USE [sweetsalesdbnopricerule]
GO
/****** Object:  StoredProcedure [sweetsalesdbnopr].[GetOrderSummaryReport]    Script Date: 12/3/2014 10:14:15 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [sweetsalesdbnopr].[GetOrderSummaryReport]
	@vTransactionDate datetime='2014-12-03 00:00:00.000',

	@vCustomerId int=44

AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

	  Declare @SQLQuery AS NVarchar(4000)
    Declare @ParamDefinition AS NVarchar(2000) 

	Set @SQLQuery = ' SELECT xx.ItemId,xx.Quantity, i.Name FROM 
  (
  SELECT  od.ItemId, SUM(CONVERT(int, ISNULL(od.Quantity,0))) AS Quantity FROM dbo.OrderDetails od 
   WHERE 
   od.OrderId IN 
  (SELECT id FROM dbo.Orders o WHERE 1=1'

  IF @vTransactionDate IS NOT NULL
	Set @SQLQuery = @SQLQuery + ' and o.ShippingDate=@vTransactionDate'
	  IF @vCustomerId IS NOT NULL
	Set @SQLQuery = @SQLQuery + ' and  o.CutomerId=@vCustomerId'
	
	Set @SQLQuery = @SQLQuery + ') GROUP BY od.ItemId )xx INNER JOIN dbo.Items i ON i.Id=xx.ItemId'
	Set @ParamDefinition =      ' @vTransactionDate datetime,
                @vCustomerId int'
 Execute sp_Executesql     @SQLQuery, 
                @ParamDefinition, @vTransactionDate, @vCustomerId

 --SELECT xx.ItemId,xx.Quantity, i.Name FROM 
 -- (
 -- SELECT  od.ItemId, SUM(CONVERT(int, ISNULL(od.Quantity,0))) AS Quantity FROM dbo.OrderDetails od 
 --  WHERE 
 --  od.OrderId IN 
 -- (SELECT id FROM dbo.Orders o WHERE o.ShippingDate=@vTransactionDate)
 -- GROUP BY od.ItemId
 -- )xx INNER JOIN dbo.Items i
 -- ON i.Id=xx.ItemId
    
	
END