Post reply

Invalid Parsename

  • December 8, 2018 at 11:39 am

    #100988

    Comments posted to this topic are about the item Invalid Parsename

  • December 8, 2018 at 11:07 pm

    #2015826

    Good question, thanks Steve.

    ...

  • December 9, 2018 at 9:42 pm

    #2015841

    Nice question.  I don't use it much, but there's always something to learn, especially from the built-in functions.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • December 9, 2018 at 9:57 pm

    #2015843

    Interesting question, thanks, Steve

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • December 10, 2018 at 7:09 am

    #2015866

    Still not sure where to use this, but it is an interesting function. Glad you all enjoyed it.

  • December 10, 2018 at 10:44 am

    #2015917

    Steve Jones - SSC Editor - Monday, December 10, 2018 7:09 AM

    Still not sure where to use this, but it is an interesting function. Glad you all enjoyed it.

    It would be good to hear of a use case for this function. Surely it was created for some purpose in mind, but I sure can't think of any reason I would use it. Has anyone had a real world use for this function?

  • December 11, 2018 at 1:34 am

    #2015967

    chris geswein - Monday, December 10, 2018 10:44 AM

    It would be good to hear of a use case for this function. Surely it was created for some purpose in mind, but I sure can't think of any reason I would use it. Has anyone had a real world use for this function?

    I don't think I've ever seen a real-world use that involves the intended use of this command but I've seen many examples of use with IP addresses and suchlike. A search of this site will produce a host of examples.

    Steve Hall
    Linkedin
    Blog Site

  • December 12, 2018 at 5:11 am

    #2016081

    ahh the old curse of knowing the correct answer but clicking the wrong one!

    good question steve,

    ta

    ---------------------------------------------------------------------------------------
    The more you know, the more you know that you dont know

  • December 12, 2018 at 6:57 am

    #2016088

    chris geswein - Monday, December 10, 2018 10:44 AM

    Steve Jones - SSC Editor - Monday, December 10, 2018 7:09 AM

    Still not sure where to use this, but it is an interesting function. Glad you all enjoyed it.

    It would be good to hear of a use case for this function. Surely it was created for some purpose in mind, but I sure can't think of any reason I would use it. Has anyone had a real world use for this function?

    Since we use named schemas a lot, I use it to parse inputs from humans for table names, etc.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • December 12, 2018 at 9:52 am

    #2016118

    Jeff Moden - Wednesday, December 12, 2018 6:57 AM

    chris geswein - Monday, December 10, 2018 10:44 AM

    Steve Jones - SSC Editor - Monday, December 10, 2018 7:09 AM

    Still not sure where to use this, but it is an interesting function. Glad you all enjoyed it.

    It would be good to hear of a use case for this function. Surely it was created for some purpose in mind, but I sure can't think of any reason I would use it. Has anyone had a real world use for this function?

    Since we use named schemas a lot, I use it to parse inputs from humans for table names, etc.

    Interesting! That's definitely the first time I've heard a real-world application where someone is actually parsing what it was intended to parse.

  • December 12, 2018 at 7:50 pm

    #2016172

    chris geswein - Wednesday, December 12, 2018 9:52 AM

    Jeff Moden - Wednesday, December 12, 2018 6:57 AM

    chris geswein - Monday, December 10, 2018 10:44 AM

    Steve Jones - SSC Editor - Monday, December 10, 2018 7:09 AM

    Still not sure where to use this, but it is an interesting function. Glad you all enjoyed it.

    It would be good to hear of a use case for this function. Surely it was created for some purpose in mind, but I sure can't think of any reason I would use it. Has anyone had a real world use for this function?

    Since we use named schemas a lot, I use it to parse inputs from humans for table names, etc.

    Interesting! That's definitely the first time I've heard a real-world application where someone is actually parsing what it was intended to parse.

    If you take a look at some of the system stored procedures that MS provides us, that seems to be what they use it for, as well.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply