0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for gardeners and landscapers

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

fork query

edited aug 7 12

created aug 3 12 conradfrix