procedure to take most viewed products?
By Zaif Ullah   Posted on June-28-2018 692
MS Sql Server
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
By zaifullah489-000001   28-Jun-2018
Views 692