Forum Replies Created

Viewing 15 posts - 886 through 900 (of 4,080 total)

  • RE: i need to do a reverse lookup on zip and get city and state for us and canada.

    Whups. What I meant to say was country foundries. They even deliver mail to rural metal casters.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: i need to do a reverse lookup on zip and get city and state for us and canada.

    Another thing to remember (in the U.S. at least) is that zip codes can also span city boundaries and even county boundaries. It's not a 1-1 relationship. ...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    I've actually worked on an IBM system that processed 96-column punched cards. Not eighty, 96. They were about the size of a zip...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Problem with performance of Geospatial Query

    Howard, a couple of quick questions:

    (1) Is there a maximum distance from a customer to a store? If they live in rural Alaska, do you ever...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: PIVOT Question

    You're welcome. Let us know if you have any questions.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: PIVOT Question

    A simple crosstab should work. I'm typing this freehand, so apologies in advance for any errors.

    select team

    ,max(case when rotation = 'Primary' then person else null end) as...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Optimize hint has huge implications. Why?

    Nico, I didn't intend to insult you personally. I'm sure you are a bright guy like most everyone else who hangs out here.

    And yet, your...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Optimize hint has huge implications. Why?

    Whups, sorry Ninja. I just read back and saw where you had already dealt with it.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Optimize hint has huge implications. Why?

    nico van niekerk (12/2/2011)


    The temp table was not #tmp but @tmp, a table definition and one cannot create indexes on table definitions. Its residence in memory makes it faster than...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Dynamic SQL in a Function (again)

    It would be nice to know the nature of what the dynamic code does, so we could completely understand the problem, but here are a couple of thoughts to maybe...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: (Re)Sorting records

    A good carry-away lesson from this is that set-based solutions are possible, even easy, whenever you can define the sets properly. The failed solution I attempted treated...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: (Re)Sorting records

    Drew that's elegant. Simple and effective. Applause, thunderous applause.

    Your insight that the relative order of the remaining prods and the remaining slots would...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: (Re)Sorting records

    Halford, I'm sorry but I couldn't make it work. You're going to need a loop, a cursor, or a recursive cte.

    Anyone else who wants to try should...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: (Re)Sorting records

    I see the problem and I think I understand where you are going with your proposed solution. It may not be possible to do this without some...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: t-sql query to populate some data into a new table

    Sorry, but from reading your text description, I have no idea what you are trying to accomplish. Could you please show some examples?

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Viewing 15 posts - 886 through 900 (of 4,080 total)