0

Please login or register to vote for this query.

(click on this box to dismiss)

Give me a list of votes I casted.

Q&A about the site for expert genealogists and people interested in genealogy or family history

-- Which votes did I gave?
-- Give me a list of votes I casted.

DECLARE @UserId int = ##UserId##

SELECT
    Votes.PostID,
    Votes.BountyAmount,
    Posts.Title
FROM 
    Votes
    INNER JOIN Posts ON Posts.ID = Votes.postID
WHERE 
    Votes.UserId = @UserId

fork query

edited feb 20 13 anonymous

created may 24 10 sam.saffron