The dynamic unpivoter.

  • john_corcoran

    SSC Rookie

    Points: 33

    Comments posted to this topic are about the item The dynamic unpivoter.

  • Tony Trus

    SSChasing Mays

    Points: 654

    This seems very promising however of the 10 tables I tried in a customer's erp system it did not work on a single one. All 10 tables had a primary key. Also, you might want to change the alter to a create since the sp wont exist for whomever downloads it. If you release another version I would definitely be interested. Thanks for contributing!

    Tony

  • john_corcoran

    SSC Rookie

    Points: 33

    Hi Tony

    I updated the SP to be a create rather than an alter. I also tried running the SP on a new database that I have and it worked fine. One requirement is that the SP has to be on the same DB as the the table that you're going to pivot. Do you any get any errors? Let me know the steps that you're doing?

    Thanks

    John

  • Tim Wilson-Brown

    Ten Centuries

    Points: 1395

    Hi John,

    I've unpivoted NULLs quite successfully before. It just takes a value column that is NULLable to do it.

    And I'm a little concerned about your use of varchar(255) rather than sysname {nvarchar(128)} for column names, or nvarchar(256) for quoted column names.

    Similarly, I'm concerned about using varchar(255) for values, rather than nvarchar(255).

    It could cause collation or character translation issues for column names or values, which contain symbols or accented characters.

Viewing 4 posts - 1 through 4 (of 4 total)

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