Kevin Oppenheimer

My feedback

  1. 523 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    26 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 72

    <=-=Mar 10 2016 11:26AM=-=>

    It’s a shame that this was submitted as just a “suggestion”. It should actually be listed as a “bug” because there’s only a comparatively small set of use cases where enumeration of the result set of elements is not important.

    <=-=Mar 11 2016 12:47PM=-=>

    I agree that an order column is required; one example use case is where two lists are passed in, and ordinal positions in one list correspond to positions in the other.

    <=-=Mar 11 2016 3:12PM=-=>

    Please see the related suggestion: STRING_SPLIT needs “RemoveEmptyEntries” option, like String.Split in .NET ( https://connect.microsoft.com/SQLServer/feedback/details/2462002/ ).

    <=-=Mar 12 2016 12:02PM=-=>

    This kind of function is primarily needed for de-serializing previously serialized arrays of values of any type format-able as text.
    I therefore recommend to have the result set of this function work excellent with this use-case.

    With de-serialized arrays there is a need to…

    Kevin Oppenheimer supported this idea  · 
  2. 10 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Logic Apps » Enterprise Integration  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Kevin Oppenheimer commented  · 

    I have not found a workaround. So, I could not use logic apps. For large files, I'm able to handle them easily using the Cozyroc controls with SSIS.

    An error occurred while saving the comment
    Kevin Oppenheimer commented  · 

    I often receive large EDI files that I need to process. The X12 834 can be especially big. Currently Logic apps can handle a file of about 6MB. When that file is decoded is translates to a payload of about 98MB. When the payload reaches 100MB the logic app breaks. 7MB EDI Files will break it. Please enhance this feature to handle larger files.

    Kevin Oppenheimer supported this idea  · 

Feedback and Knowledge Base