0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

SELECT 

    TOP ##TopCount:INT?100## -- optional 100


    ROW_NUMBER() OVER (ORDER BY p.CreationDate ASC) AS 'ID',
    p.Id AS [Post Link],
    --p.PostTypeId AS TID,
    p.Id AS PID,
    p.OwnerUserId AS UID,
    p.CreationDate AS Created
    
FROM Posts AS p

WHERE p.PostTypeId = 1
AND p.Tags LIKE '%<vba>%'

ORDER BY p.CreationDate ASC

view current version

edited feb 29

created feb 29 VBasic2008