PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
ALTER PROCEDURE [dbo].[uspGetTopCrossSells] @customerId int, @ProductCategory nvarchar (50), @Score float Output, @ClientKey nvarchar (50) Output, @Ranking int Output AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; SELECT Score, ClientKey, Ranking FROM CrossSellScore css, ItemCategory ic WHERE customerid = @customerid and score > 6.0 and css.ItemCategoryId = ic.Id and description like @ProductCategory+'|%' and EndDate=(Select max(EndDate) from DatePeriod) Order By Score Desc END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|How to check if SQL server database is being backed up by SQL management studio ?||13||82|
|Access 2003, percentage between two fields||18||16|
|Output Different in Excel Compared In SSMS||8||14|
Join the community of 500,000 technology professionals and ask your questions.