Tag 'Ownership' - Taxonomist

6

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.

Korean Language Meta

Q&A about the site for linguists, teachers and students of the Korean language

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
BEGIN
   print 'processing tag ' + @tname;
   
   fetch next from TAGS into @tid, @tname, @tcnt
END

select * from #tago

Enter Parameters

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