Seems it works now.

I would like to understand the query

select RowNum, [1],[2],[3],[4],[5],[6],[7],[8],[9]
from
  (select RowNum, ColumnNum, case when substring(@PuzzleIn,CoordinateID,1) != 0 then substring(@PuzzleIn,CoordinateID,1) end Value...

Thanks.

Learned new thing.

Wasn't aware of delete CTE.

Sorry. i don't see how you can delete from the cte and still have the data that you don't want to delete in the true table.

For me, just restarting the sql serve fixed the problem. After restart the recovering could be done.

I think that this is the first step to be done when facing the...

Nice article. I have used the script and created the HTM email but I have noticed that the results where truncated at some length and instead of getting 761 rows...