Forum Replies Created

Viewing 15 posts - 4,996 through 5,010 (of 59,089 total)

  • Reply To: How to use parameter in set function and calculated field in where

    fahad.kazi wrote:

    Thank you all for the quick response, despite it being a long weekend in some countries. A blend of these has certainly addressed my issue.

    You guys rock!

    Awesome... can you...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 5, 2021 at 3:20 pm

    #3903592

  • Reply To: Reading and Writing your Database's Documentation using JSON

    james.of.rivendell wrote:

    hi Phil

    Could you explain what this means?

    "We are in Marcel Proust territory already."

    What issue is this describing?

    If you do a search in the article for the first reference, you'll...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 5, 2021 at 3:16 pm

    #3903590

  • Reply To: How to handle transfer quantity from location to another ?

    ahmed_elbarbary.2010 wrote:

    yes invoice id is invoice no

    and i use this field to store Purchase ID AND  sales or consume ID

    but my issue How to handle transfer from inventory to another...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 5, 2021 at 3:10 pm

    #3903589

  • Reply To: Top SQL Queries to Safeguard JIRA

    I wasn't involved much in the installation of the database for the Jira application except that I was told by the vendor that Atlassian won't even talk to someone with...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 5, 2021 at 3:02 pm

    #3903586

  • Reply To: How to handle transfer quantity from location to another ?

    First, you keep talking about "invoice no" but you have nothing in any of the tables that is an "invoice no".  Do you mean "InvoiceID" in the [Inventory] table?

    And, surely,...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 4, 2021 at 12:22 am

    #3903228

  • Reply To: Inner Join query problems

    ScottPletcher wrote:

    Jeff Moden wrote:

    gjoelson 29755 wrote:

    OMG !!

    Wow .....the cross apply worked like a Charm.  and it was quick , even though now checking the table index is Clustered on identity, I will...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 4, 2021 at 12:00 am

    #3903227

  • Reply To: Top SQL Queries to Safeguard JIRA

    @ Brian...

    I agree that a good DBA is necessary to prevent performance from tanking on 3rd party databases but, I'm not sure I'm so happy with Jira as a lot...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 3, 2021 at 9:52 pm

    #3903214

  • Reply To: Happy Birthday USA!

    skeleton567 wrote:

    God bless America, my home, sweet home.

    + 1,000,000,000

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 3, 2021 at 9:40 pm

    #3903213

  • Reply To: Inner Join query problems

    gjoelson 29755 wrote:

    OMG !!

    Wow .....the cross apply worked like a Charm.  and it was quick , even though now checking the table index is Clustered on identity, I will go ahead...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 3, 2021 at 9:37 pm

    #3903212

    • Viewing 15 posts - 4,996 through 5,010 (of 59,089 total)