Forum Replies Created

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

  • Reply To: Navigating Trees With CTE

    This is awesome.

  • RE: Distinct and count

    Isn't just as simple as adding a count() and a group by?

    SELECT MAGINUS_SUPPLIER.SUPPLIER_ACCOUNT

    , MAGINUS_SUPPLIER.SUPPLIER_NAME,MAGINUS_SUPPLIER.ADDRESS1

    , MAGINUS_SUPPLIER.ADDRESS2

    , MAGINUS_SUPPLIER.ADDRESS3

    , MAGINUS_SUPPLIER.ADDRESS4

    , MAGINUS_SUPPLIER.ADDRESS5

    , MAGINUS_SUPPLIER.ADDRESS6

    , MAGINUS_SUPPLIER.POSTCODE

    , MAGINUS_SUPPLIER.PAYMENT_TERM

    , MAGINUS_BANK_DETAILS.BANK_SORT_CODE

    , MAGINUS_BANK_DETAILS.BANK_ACCOUNT_NUM

    , MAGINUS_BANK_DETAILS.BANK_REFERENCE

    , xxxCustDelivDump.InvDate

    , COUNT(*)

    FROM MAGINUS_SUPPLIER

    INNER JOIN MAGINUS_BANK_DETAILS...

  • RE: How to save results of a procedure with more than one result set

    That seems like a lot of work, when you could modify the original stored procedure to save the multiple result sets to a temp table and then return them all...

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