Advertisement
| 06.17.2008 at 07:37AM PDT, ID: 23491680 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: |
DECLARE @StartTime DATETIME
DECLARE @EndTime DATETIME
DECLARE @CatStart INT
DECLARE @CatEnd INT
DECLARE @TheDay DATETIME
DECLARE @TheDayPlusOne DATETIME
DECLARE @TheCat INT
DECLARE @Count INT
DECLARE @Search VARCHAR(10)
SET @StartTime = 'April 17 2008'
SET @EndTime = 'June 17 2008'
SET @CatStart = 1
SET @CatEnd = 11
SET @TheDay = @startTime
SET @TheDayPlusOne = DATEADD(DAY, 1, @TheDay)
SET @TheCat = @CatStart
SET NOCOUNT ON
WHILE @TheDay < @endTime
BEGIN
WHILE @TheCat < @CatEnd
BEGIN
SET @Search = '%cat=' + CAST(@TheCat AS VARCHAR) + '%'
SET @Count = (
SELECT COUNT (DISTINCT WS.[UNIQUE_IDENTIFIER_ID])
FROM [WAP_SESSIONS] AS WS
INNER JOIN [PAGE_HITS] AS PH ON WS.[WAP_SESSION_ID] = PH.[WAP_SESSION_ID]
INNER JOIN [QUERY_STRINGS] AS QS ON PH.[QUERY_STRING_ID] = QS.[QUERY_STRING_ID]
WHERE QS.[QUERY_STRING] LIKE @Search
AND WS.[CLIENT_ID] = 50510
AND WS.[DATE_CREATED] BETWEEN @TheDay AND @TheDayPlusOne
)
PRINT CAST(@TheCat AS VARCHAR) + ', ' + CAST(@TheDay AS VARCHAR) + ', ' + CAST (@Count AS VARCHAR)
SET @TheCat = @TheCat + 1
END
SET @TheCat = @CatStart
SET @TheDay = DATEADD(DAY, 1, @TheDay)
SET @TheDayPlusOne =DATEADD(DAY, 1, @TheDay)
END
SET NOCOUNT OFF
|
Advertisement
