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



You may also read following recent Post

Submit Post - Article - Ask a Question - Ask an Interview Question - Submit Useful Links