Forum Replies Created

Viewing 15 posts - 436 through 450 (of 938 total)

  • RE: The T-SQL Quiz

    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...

  • RE: The T-SQL Quiz

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

  • RE: The T-SQL Quiz

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

  • RE: The T-SQL Quiz

    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...

  • RE: The T-SQL Quiz

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

  • RE: The T-SQL Quiz

    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%...

  • RE: The T-SQL Quiz

    Just a slight modification to one of the examples:

    WITH

    Nbrs(n) AS (

        SELECT...

  • RE: Primary key: ZIPCode, State

    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...

  • RE: Primary key: ZIPCode, State

    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...

  • RE: Stupid Question

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

  • RE: Question of the Day for 21 May 2007

    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...

  • RE: Upgrades

    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...

  • RE: SQL 2000 DBA Toolkit Part 4

    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

  • RE: SQL 2005 for the SQL2K Developer Part 2

    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...

  • RE: SQL 2005 for the SQL2K Developer Part 2

    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)...

Viewing 15 posts - 436 through 450 (of 938 total)