Viewing 15 posts - 436 through 450 (of 938 total)
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...
May 29, 2007 at 12:05 pm
Yes, I just posted the code to calculate LCM and GCD So I suppose the code needs to change to calculate the LCM...
May 29, 2007 at 8:56 am
I was just gearing the solution to the problem at hand, with the parameters given The least common multiple is an interesting problem...
May 29, 2007 at 8:32 am
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...
May 29, 2007 at 8:29 am
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%...
May 29, 2007 at 8:11 am
Just a slight modification to one of the examples:
WITH
Nbrs(n) AS (
SELECT...
May 27, 2007 at 11:26 pm
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...
May 25, 2007 at 11:00 am
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...
May 24, 2007 at 8:48 am
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...
May 21, 2007 at 8:19 am
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...
May 18, 2007 at 8:38 am
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
May 14, 2007 at 12:40 pm
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...
May 14, 2007 at 8:44 am
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)...
May 11, 2007 at 6:51 pm
Viewing 15 posts - 436 through 450 (of 938 total)