• xtrmus2319 - Thursday, January 25, 2018 9:27 AM

    drew.allen - Thursday, January 25, 2018 9:24 AM

    This is the same problem as here.  Don't start a new thread just because you don't like the answers that you are getting on your original thread.

    Drew

    🙂 Bro I'm already on that subject. They just wanted detailed information.

    Well, if you want an answer, you need to provide the details.  

    For starters, your design is flawed.  it appears, based upon the limited information you have provided, that this can be normalized into 2 separate tables. One for coin, the other for values and date. 
    Secondly, again, you are getting exactly what you are asking for in this query.  

    If you want to provide code to create the tables (DDL), some consumable data to fill those tables, and a sample of what you expect the output to be, then you will probably get some real answers.  
    If you do not know how to provide this information, then please read the links that are in multiple replies to your posts.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/