Home Forums SQL Server 2008 T-SQL (SS2K8) Returning a column per date in a range RE: Returning a column per date in a range

  • January 6, 2012 at 6:41 am

    #1429593

    nick-1043370 (1/6/2012)

    Hi Chris

    The bummer is it's a different date range each time! Ideally I'd like whatever code I use to get the date range in question first, i.e. find the min check-in date and max check-out date from the dataset, and show date columns accordingly.

    I didn't think it would be easy!:-)

    It's surprisingly easy when you have sample data to work with 😉

    Please could you read the article linked to in my sig, Nick? You're new here - welcome aboard - the article will explain to you how best to pose a question for a speedy and accurate reply (which you've done) and how to set up easily-consumable sample data.

    Cheers

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]