I was just working on the CTE version of the LCM algorithm when I saw David's post.  Anyway, here's what I came up with (please excuse any typos, I had...

Yes, I just posted the code to calculate LCM and GCD   So I suppose the code needs to change to calculate the LCM...

I was just gearing the solution to the problem at hand, with the parameters given   The least common multiple is an interesting problem...

I personally wouldn't agree with using 15 rather than "5 and 3".  If we posed the problem using x and y variables rather than numbers then we would be need...

Hey it's not running on my SQL 4.2 servers!  LOFL

God-awful loops and cursors.  It's all I seem to see these days, and getting people to think about changing them?  Even when you can demonstrate 100%, 200%, 500%, or 1000%...

Just a slight modification to one of the examples:

WITH

Nbrs(n) AS (

    SELECT...

FIPS are Federal Information Processing Standards.  FIPS State codes a two-digit state code, county codes are 3 digits.  There are also MSA (metropolitan statistical area) codes used by the Census Bureau...

A geographic location can have many ZIP Codes, as New York City has many, many ZIP codes assigned.  There are even buildings (like the old WTC buildings, and some manufacturing...

We're not all shallow!  Give me a call, 555-1212!

Actually the question is "How can you get the number of columns involved in any constraint of any table in SQL Server 2005?"  None of the answers returns an...

About those ongoing costs you mentioned - a lot of those can be minimized by "doing it right the first time."  Back in the day I had to research some...

Hi Patrick,

I haven't personally done anything with asymmetric encryption on SQL 2000 yet.  Most likely I won't, but that doesn't mean someone else out there hasn't, or won't.

Thanks

Absolutely.  The example given for the Top 10 was too simple to benefit (unless of course you're trying to port something to/from a system that does not support the TOP keyword).  If...

What's more difficult is something like this:

UPDATE Products

SET UnitPrice = 0.9 * UnitPrice

WHERE ProductID IN

(

SELECT ProductID FROM(

SELECT ROW_NUMBER() OVER (ORDER BY UnitPrice DESC) AS Number, ProductID FROM Products)...