Tag 'Ownership' - Taxonomist


Please login or register to vote for this query.

(click on this box to dismiss)

Identify who first created a tag, and how many questions use it.

Arts and Crafts Meta

Q&A about the site for artists and crafters

create table #tago (
TagId int,
TagName NVarchar(25),
TagCount int,
owner int,
awarded NVarchar(3),
cpost int,
revisionlink NVarchar(250))

declare @tid int, @tname NVarchar(25), @tcnt int;
declare TAGS cursor for select Id, TagName, "Count" from Tags

open TAGS

fetch next from TAGS into @tid, @tname, @tcnt
while @@FETCH_STATUS = 0
   print 'processing tag ' + @tname;
   fetch next from TAGS into @tid, @tname, @tcnt

select * from #tago

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results