Dump your own posts, e.g. for backup purposes.
Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more
-- Dump your own posts
-- Dump your own posts, e.g. for backup purposes.
DECLARE @UserId int = ##UserId## ;
WITH transclosure(Id, OwnerUserId, ParentId, Title, Body) as
( select a.Id, a.OwnerUserId, a.ParentId, a.Title, a.Body from Posts as a
where OwnerUserId = @UserID
SELECT b.Id, b.OwnerUserId, b.ParentId, b.Title, b.Body
FROM Posts as b,
transclosure as c
WHERE b.OwnerUserId = c.ParentId
select * from transclosure ;