Suggested Edit Votes for a user on a day

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT Row_number() 
                  OVER ( 
                    ORDER BY sev.id) rn, 
                userid, 
                creationdate, 
                suggestededitid, 
                'http://stackoverflow.com/suggested-edits/' + cast(suggestededitid  as varchar) as [Edit Link],
                vt.Name 
         FROM   suggestededitvotes sev 
         INNER JOIN votetypes vt 
               ON sev.votetypeid = vt.id 
         WHERE  userid = ##TheUserid:int##
                and Cast(creationdate AS DATE) = ##editday:string##
ORDER BY sev.id

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results