DECLARE @RC int
DECLARE @SectionID int
DECLARE @ParentID int
DECLARE @AllowDuplicatePosts bit
DECLARE @DuplicateIntervalInMinutes int
DECLARE @Subject nvarchar(256)
DECLARE @UserID int
DECLARE @PostAuthor nvarchar(64)
DECLARE @Body nvarchar(10)
DECLARE @FormattedBody nvarchar(10)
DECLARE @EmoticonID int
DECLARE @IsLocked bit
DECLARE @IsSticky bit
DECLARE @IsApproved bit
DECLARE @StickyDate datetime
DECLARE @PostType int
DECLARE @PostDate datetime
DECLARE @UserHostAddress nvarchar(32)
DECLARE @PropertyNames nvarchar(1000)
DECLARE @PropertyValues nvarchar(1000)
DECLARE @SettingsID int
DECLARE @IsTracked bit
DECLARE @PostID int
DECLARE @ThreadID int
DECLARE @PostConfiguration int
DECLARE @UpdateSectionStatistics bit
DECLARE @UserTime datetime
DECLARE @ApplicationPostType int
DECLARE @PostName nvarchar(256)
DECLARE @ThreadStatus int
DECLARE @Points int
DECLARE @PostDisplayName nvarchar(64)
DECLARE @AutoApprove bit

DECLARE @PostLevel int
DECLARE @SortOrder int

-- TODO: Set parameter values here.
--begin tran

declare cr cursor for
	SELECT PostID
	FROM sqlblogmain..TempPost
--	WHERE PostID NOT IN (9, 19, 20)
--	and PostID >= 10

open cr

fetch cr into @PostID

while @@fetch_status = 0
begin

	SELECT @ThreadID = 0 -- ThreadID
		  ,@ParentID = 0
		  ,@PostAuthor = PostAuthor
		  ,@UserID = UserID
		  ,@SectionID = SectionID
		  ,@PostLevel = 1
		  ,@SortOrder = 1
		  ,@Subject = Subject
		  ,@PostDate = PostDate
		  ,@IsApproved = IsApproved
		  ,@IsLocked = IsLocked
		  --,@IsIndexed = IsIndexed
		  --,@TotalViews = TotalViews
		  ,@Body = CAST(PostID AS nvarchar(10)) --CAST(Body as ntext)
		  ,@FormattedBody = CAST(PostID AS nvarchar(10))  --cast(FormattedBody as ntext)
		  ,@UserHostAddress = IPAddress
		  ,@PostType = PostType
		  ,@EmoticonID = EmoticonID
		  ,@PropertyNames = PropertyNames
		  ,@PropertyValues = PropertyValues
		  ,@SettingsID = SettingsID
		  --,@AggViews = AggViews
		  ,@PostConfiguration = 2 --PostConfiguration
		  ,@PostName = PostName
		  ,@UserTime = UserTime
		  ,@ApplicationPostType = ApplicationPostType
		  ,@Points = Points
		  --,@RatingSum = RatingSum
		  --,@TotalRatings = TotalRatings
		  --,@PointsUpdated = PointsUpdated
		,@StickyDate = GetDate()
	  FROM sqlblogmain..TempPost
	WHERE PostID  = @PostID


	--SELECT * FROM sqlblogmain..TempPost
	--WHERE PostID NOT IN (9, 19, 20)
	--and PostID >= 10


	--EXECUTE @RC = sqlblogmain2.dbo.cs_Post_CreateUpdate 
	EXECUTE sqlblogmain.dbo.cs_Post_CreateUpdate 
	   @SectionID
	  ,@ParentID
	  ,0 -- @AllowDuplicatePosts
	  ,0 -- @DuplicateIntervalInMinutes
	  ,@Subject
	  ,@UserID
	  ,@PostAuthor
	  ,@Body
	  ,@FormattedBody
	  ,@EmoticonID
	  ,@IsLocked
	  ,0 -- @IsSticky
	  ,@IsApproved
	  ,@StickyDate
	  ,@PostType
	  ,@PostDate
	  ,@UserHostAddress
	  ,@PropertyNames
	  ,@PropertyValues
	  ,@SettingsID
	  ,@IsTracked
	  ,@PostID OUTPUT
	  ,@ThreadID OUTPUT
	  ,@PostConfiguration
	  ,@UpdateSectionStatistics
	  ,@UserTime
	  ,@ApplicationPostType
	  ,NULL --@PostName
	  ,0 -- @ThreadStatus
	  ,@Points
	  ,@PostAuthor -- @PostDisplayName
	  ,@AutoApprove;


	UPDATE cs_posts
	SET Body = TempPost.Body, FormattedBody = TempPost.Body
	FROM cs_posts 
		INNER JOIN TempPost ON CAST(cs_posts.Body as nvarchar(10)) = Cast(TempPost.PostID as nvarchar(10))
	

	fetch cr into @PostID
end


select * from cs_posts
select * from cs_threads

close cr
deallocate cr



--rollback tran


-- SELECT * FROM sqlblogmain..TempPost WHERE PostID NOT IN (9, 19, 20)