Forum Replies Created

Viewing 11 posts - 1 through 12 (of 12 total)

  • RE: Help With Update Statement

    Thanks . I will try that

  • RE: SQL Update with Subquery

    Thanks everyone. Sorry I never responded. But the answers above fixed my issue. Thanks everyone

  • RE: SQL Update with Subquery

    Thom A - Wednesday, August 23, 2017 7:06 AM

    Jeff Moden - Tuesday, August 22, 2017 10:25 PM

  • RE: SQL Update with Subquery

    Thom A - Wednesday, August 23, 2017 7:06 AM

    Jeff Moden - Tuesday, August 22, 2017 10:25 PM

  • RE: Select Statement Help

    Thank you@

  • RE: Help with SQL Query

    Lowell - Monday, July 31, 2017 1:00 PM

    this does what you are asking, I guess:
    this assumes your a ticket is always opened...

  • RE: Help with SQL Query

    same ticketid can be opened and closed multiple times due to correspondence. There is a column labeled TicketHistoryID which is the unique ID for each transaction.

    Its basically...

  • RE: Help with SQL Query

    So the ticketid Is a uniqueID for a particular issue. So lets say I have an issue resetting my password. So a ticket is created, lets say its ticketID =...

  • RE: Help with SQL Query

    Lowell - Monday, July 31, 2017 10:36 AM

    Phils logic looks like it will still work.
    I converted your paste to consumable data
    [code...

  • RE: Help with SQL Query

    Phil,

    Thanks. The code below gets me to the data table I posted above.

  • RE: Help with SQL Query

    Thanks Phil. One more question. How would I use the above select query if I have multiple records. See Below

    Viewing 11 posts - 1 through 12 (of 12 total)