Viewing 3 posts - 1 through 3 (of 3 total)
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...
July 15, 2014 at 1:58 pm
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...
September 6, 2012 at 8:24 am
Viewing 3 posts - 1 through 3 (of 3 total)