Of course, if you want to go for broke with simplicity of code, break out your trusty Tally Table. SELECT EXP(SUM(LOG(N))) Factorial FROM...
Heh... I wasn't sure that a whole lot of people would know what a zero exponent would be or do so stuck with the long hand. And, aApologies on my...
I realize that I'm responding to a post more than 6 years old. ;-) The largest factorial you can calculate using native datatypes in SQL Server is...
See the following article for how to build a "Tally" (or "Numbers") table and how it works to replace a While Loop in a manner similar to what...
Heh... Dang... Long time no see, Frank. I forgot you were a moderator on this fine forum and it's good to see the familiar shark face smile of your...
Whether you use a Tally table, spt_values, or a CTE, if you don't know how it works, it will be a limited tool for you. There is an article that...
Lordy, it's been a very long time since I've seen or heard from you, Frank. Thank you for the nice welcome.
There's some really dangerous code in some of these articles... some of them recent. I just ran across one that compares dates using a bloody...
Separate names with a comma.
