Home Forums SQL Server 2008 T-SQL (SS2K8) T sql for patient arrivals, transfers In and Out and discharges and census on a hospital floor by hour RE: T sql for patient arrivals, transfers In and Out and discharges and census on a hospital floor by hour

  • November 17, 2013 at 3:44 am

    #1666920

    Now we have (almost) ready to use sample data.

    "Almost" because I can't load the sample data "as is" due to a different DATEFORMAT setting, so you might consider in the future to always post date values as YYYYMMDD instead of MM/DD/YY.

    What we also need is your expected result based on your sample data in the format you need it. Currently we can just guess what you're looking for...


    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]