procedure to take recent viewed products?
- MS Sql Server
- 684
- June-28-2018
- by Zaif Ullah
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
Jack Carter
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!
you can view the more detail via link https://www.youtube.com/watch?v=HpZgwHU1GcIChing xang
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!
Danial Comb
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!
Jack Carter
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!