EXEC sp_executesql N'SELECT r.id,  r.Quantity, r.UnitCost, r.DateReceived,
                     s.Id , s.Description,
                     p.Id, p.Number, p.Description, p.StockClass,
                     mp.Id , mp.Number, mp.ManufacturerId, mp.Description,
                     m.Id , m.Description, m.ShortDescription,
                     c.Id, c.Description,
                     pc.Id, pc.Name, pc.Description
              FROM   PartReceipt r
              INNER JOIN Supplier s ON r.SupplierId = s.Id
              INNER JOIN Part p on r.PartId = p.Id
              INNER JOIN ManufacturerPart mp ON p.ManufacturerPartId=mp.Id
              INNER JOIN Manufacturer m ON mp.ManufacturerId = m.Id
              LEFT JOIN Color c ON p.ColorId=c.Id
              LEFT JOIN ProductCategory pc ON p.ProductCategoryId=pc.Id
              WHERE s.Id=@supplierId',N'@supplierId int',@supplierId=40


EXEC sp_executesql N'SELECT r.id,  r.Quantity, r.UnitCost, r.DateReceived,
                     s.Id , s.Description,
                     p.Id, p.Number, p.Description, p.StockClass,
                     mp.Id , mp.Number, mp.ManufacturerId, mp.Description,
                     m.Id , m.Description, m.ShortDescription,
                     c.Id, c.Description,
                     pc.Id, pc.Name, pc.Description
              FROM   PartReceipt r
              INNER JOIN Supplier s ON r.SupplierId = s.Id
              INNER JOIN Part p on r.PartId = p.Id
              INNER JOIN ManufacturerPart mp ON p.ManufacturerPartId=mp.Id
              INNER JOIN Manufacturer m ON mp.ManufacturerId = m.Id
              LEFT JOIN Color c ON p.ColorId=c.Id
              LEFT JOIN ProductCategory pc ON p.ProductCategoryId=pc.Id
              WHERE s.Id=@supplierId AND r.DateReceived = @dateReceived',N'@supplierId int,@dateReceived datetime',@supplierId=40,@dateReceived='2015-04-03 00:00:00'