Forum Replies Created

Viewing 15 posts - 1 through 15 (of 26 total)

  • Reply To: Pizza Math

    While your comparison holds, your math doesn't.  Area is pi * r^2.  A 9 inch pizza is 4.5 inches radius.  Therefore about 63.6 square inches.

  • Reply To: Inlining Scalar UDFs

    One of the correct answers is Function 2, but I don't see that one. I only see 1, 3, 4 and 5.

    Edit: Mea Culpa, it's not labeled like the others.

    • This reply was modified 4 years, 7 months ago by  gary.rumble.
  • Reply To: Inserting In the Middle

    Actually I wouldn't do any of those.  I would use a text editor and put 88, between 95 and 94.

     

  • Reply To: Printing Dates

    I selected the matching format even though the date didn't match.  Got it right, but it was just a guess.

    Output from SSMS: Jan 18 2019  8:23PM

  • Reply To: Dos and Don'ts of Dynamic SQL

    When I do it in SSMS I use the fact that it allows multiple lines in a single quoted string, e.g.

    declare @sql nvarchar(2000)

    set @sql =
    'select
    *
    from SomeTable st
    join...
  • RE: The Comprehensive Set

    The explanation is confusing.
    print ([x%2 for x in range(10) if x % 2 == 0]) returns 5 values, but all of them are 0 (x % 2).
    A set...

  • RE: Adding lists

    Pretty much a process of elimination.
    The first answer was a tuple and the statement would have to have been: Teams = (West, South, North)
    The third sequence rearranged the first...

  • RE: Range arguments

    <pedant>
    Based on the example, only the first argument is optional because the default increment is 1.
    </pedant>

  • RE: Python List Ranges

    peter.row - Wednesday, September 5, 2018 2:54 AM

    Urgh! So if you want all elements then using this syntax you'd have to specify...

  • RE: Added SQL Server 2008 R2 to domain, can't send email

    I'm afraid I don't remember all of the steps I took. There were many failed attempts to get this working.

    The MSA (Managed Service Account) was created on the Domain...

  • RE: Query Plan Execution Order

    Hugo Kornelis (10/27/2011)


    Good question, Paul!

    I had the correct answer,but only thanks to the fact that I attended SQL Saturday in Portland a few weeks back (just before the PASS Summit)....

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    Jeff Moden (5/4/2011)


    gary.rumble (5/3/2011)


    Jeff Moden (5/3/2011)


    gary.rumble (5/3/2011)


    Jeff Moden (5/2/2011)


    gary.rumble (5/2/2011)


    Well, so far I got:

    ...

    I think your code is too much for my server. 😉

    Yowch. The code is even split...

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    Jeff Moden (5/3/2011)


    gary.rumble (5/3/2011)


    Jeff Moden (5/2/2011)


    gary.rumble (5/2/2011)


    Well, so far I got:

    ...

    I think your code is too much for my server. 😉

    Yowch. The code is even split into batches. ...

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    Jeff Moden (5/2/2011)


    gary.rumble (5/2/2011)


    Well, so far I got:

    ...

    I think your code is too much for my server. 😉

    Yowch. The code is even split into batches. What you may...

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    Well, so far I got:

    (2 row(s) affected)

    Msg 8623, Level 16, State 1, Line 3

    The query processor ran out of internal resources and could not produce a query plan. This is...

Viewing 15 posts - 1 through 15 (of 26 total)