0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

DECLARE @SiteUrl VARCHAR(MAX)

SET @SiteUrl = (
  SELECT
    'https://' +
    CASE WHEN DB_NAME() = 'StackOverflow' THEN 'stackoverflow'
         WHEN DB_NAME() = 'ServerFault' THEN 'serverfault'
         WHEN DB_NAME() = 'SuperUser' THEN 'superuser'
         WHEN DB_NAME() LIKE 'StackExchange.%%' THEN REPLACE(DB_NAME(), 'StackExchange.', '')
         ELSE 'stackexchange' -- Default or if it doesn't match anything specific
    END +
    '.stackexchange.com/q/'
)

SELECT 
    q.Id AS QuestionId,
    q.Title AS QuestionTitle,
    q.ViewCount AS ViewCount,
    CONCAT(LOWER(@SiteUrl), q.Id) AS QuestionURL
FROM 
    Posts a
JOIN 
    Posts q ON a.ParentId = q.Id
WHERE 
    a.PostTypeId = 2 -- This denotes an Answer
    AND a.OwnerUserId = ##UserId:int##
ORDER BY 
    q.ViewCount DESC

fork query

edited feb 23

created feb 23 anonymous