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 
    p.Id AS QuestionId,
    p.Title AS QuestionTitle,
    p.ViewCount AS ViewCount,
     CONCAT(LOWER(@SiteUrl), p.Id) AS QuestionURL
FROM 
    Posts p
WHERE 
    p.PostTypeId = 1 -- This denotes a Question
    AND p.OwnerUserId = ##UserId:int##
ORDER BY 
    p.ViewCount DESC

fork query

edited feb 23

created feb 23 anonymous