Home Forums SQL Server 2008 T-SQL (SS2K8) Creating View with More Records than original table RE: Creating View with More Records than original table

  • August 24, 2017 at 1:34 am

    #1956551

    les.61 - Wednesday, August 23, 2017 8:19 PM

    1.       Can I create a view that has MORE records than the table that I am extracting data from?
    2.       Any suggestions on how to get the system to cycle through the highest maturity date and add another record (if applicable) before going on to the next record from the original table? Any web sites or links that might direct me in the right direction?

    1. Yes. A view is just a predefined SELECT statement, and doesn't have to select from one table, or could return records multiple times from the same one.
    2. I'm not entirely sure I understand your question, in all honesty. Someone else might, but It would be good if you could outline your logic in a step by step process for an individual record, it'll definitely help the understanding. Also, please ensure you provide your data in a consumable format. Can you post DDL and DLM please? Have a look at the link in my signature on how to do this.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk