procedure to take recent viewed products?

  By Zaif Ullah   Posted on June-28-2018   634

MS Sql Server

USE [saudiphone]
GO
/****** Object:  StoredProcedure [dbo].[Product_LookUp_RecentViewedProduct]    Script Date: 6/28/2018 2:26:01 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER proc [dbo].[Product_LookUp_RecentViewedProduct]

as
begin
SELECT TOP (10) rvp.ProductID ,p.Photo,p.ProductTitle,p.CategoryID,p.MinPrice  FROM RecentViewedProducts rvp
Join Product p on rvp.ProductID = p.ProductID


end

By  zaifullah489-000001    28-Jun-2018 Views  634



You may also read following recent Post

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