February 27
After some talks with Marek Adamczuk I've decided to try writing some common table expression evaluating factorials. The result is below.
DECLARE @number tinyint
SET @number = 33;
WITH FactorialCTE AS
(
SELECT
0 AS Number,
CAST(1 AS decimal(38,0)) AS Factorial
UNION ALL
SELECT
FactorialCTE.Number + 1,
FactorialCTE.Factorial * (FactorialCTE.Number + 1)
FROM FactorialCTE
WHERE Number < @number
)
SELECT Factorial
FROM FactorialCTE
WHERE Number = @number
February 07
There is the first part of my new article on TechNet Poland website. This article has title: "SQL Server 2005 - undocummented DBCC commands". Click link below to read the article.
Tools 
