Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: tsql query - if exists placement theory for optional tables

    syntax:

    ROW_NUMBER ( )

    OVER ( [ PARTITION BY value_expression , ... [ n ] ] order_by_clause )

    Thank you Sir, I have some learning to do.:-)

    "I like spaghetti because my house is made of brick."
    ~Paul Wuerzner on illogicality 2/14/86 - 11/6/11 😎

  • RE: Try to focus on the positive

    I am thankful for this site and others that guide my never-ending quest for the next solution.

    "I like spaghetti because my house is made of brick."
    ~Paul Wuerzner on illogicality 2/14/86 - 11/6/11 😎

  • RE: Calculating Elapsed Times (SQL Spackle)

    In the healthcare industry, length of stay (LOS) is always fun figuring out how to present the data.

    Usually we only count days stay with a default of 1. ...

    "I like spaghetti because my house is made of brick."
    ~Paul Wuerzner on illogicality 2/14/86 - 11/6/11 😎

Viewing 3 posts - 1 through 3 (of 3 total)