Search results

  1. T

    Select Min Date from CASE statement for date

    Thank you Mr. L, I was thinking it would have to be something more like this. I'm decent at SQL but obviously not that great :/ Thank you for taking a look. SELECT PURC_ORDER_LINE.PART_ID, PURC_ORDER_LINE.TOTAL_USR_RECD_QTY, PURC_ORDER_LINE.ORDER_QTY, PURCHASE_ORDER.STATUS...
  2. T

    Select Min Date from CASE statement for date

    Going to try something else I thought of
  3. T

    Select Min Date from CASE statement for date

    There will be multiple values for the Part ID
  4. T

    Select Min Date from CASE statement for date

    I understand select TOP 1, and I know i'm only selecting one value for the Part ID but i'm just testing it for that one, so that would not work in this case.
  5. T

    Select Min Date from CASE statement for date

    I have 3 tables where I want to grab a date from and I made a case statement for it. Is it possible for me to grab the Min date as I get multiple values for the date and I only want to grab that one? Here is my code so far. Thanks for anyone if they can help. SELECT PURC_ORDER_LINE.PART_ID...
Back
Top Bottom