Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Help - Pivot table RE: Help - Pivot table

  • August 8, 2014 at 1:30 am

    #1736316

    m.mukesh.mca2009 (8/7/2014)

    Hi, eID have only unique values but ID may have duplicate values

    That doesn't match the sample data you provided.

    ID eID inCount outCount

    41772 0 NULL NULL

    10000 1033 1 7

    10000 1034 6 1

    10000 1035 NULL 1

    10000 1036 1 NULL

    10000 1036 2 NULL

    10000 1036 1 1

    Seems like you're not really interested to get the issue resolved. I'm out.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]