How valid are migrations?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gives some stats on the validity of questions migrated into this site

Super User

Q&A for computer enthusiasts and power users

-- How valid are migrations?
-- Gives some stats on the validity of questions migrated into this site

Select Count(*) as Immigrants, Count(ClosedDate) as Closed, 100.0*Count(ClosedDate)/Count(*) as PctBadMigrations
   FROM Posts p
   INNER JOIN PostHistory ph ON ph.PostId = p.Id
   WHERE ph.PostHistoryTypeId = 17

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached