procedure to take most viewed products?
- MS Sql Server
- 829
- June-28-2018
- by Zaif Ullah
USE [saudiphone]
GO
/***** Object: StoredProcedure [dbo].[Product_LookUp_MostViewedProductList] Script Date: 6/28/2018 2:10:16 PM *****/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create proc [dbo].[Product_LookUp_MostViewedProductList]
as
begin
select Distinct Top (8) mv.ProductID, p.ProductTitle,p.Photo,p.MinPrice
,(select count(*) from RecentViewedProducts m where m.ProductId=mv.ProductId) as TotalCount from RecentViewedProducts mv
join Product p on p.ProductID = mv.ProductId
ORDER BY TotalCount DESC
end
