Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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