Pass Through Query Does Not Perform Group By

[mordja]

Hi,

I have a pass through query to a Sybase table which does not group properly. The query is


select d.businessDate, d.companyCode, c.clientCode, d.cusip, DailyBalance=Sum(p.dailyBalance), c.customerCategory, d.borrowLoanPledgeReceipt, d.issueCurrency, d.strategyCode
from CLIENT_DETAILS c, DAILY_DEAL_LEVEL_INFO d, DAILY_PNL_INFO_IN_USD p
where p.dealReference = d.dealReference
and d.clientVersionNumber = c.clientVersionNumber
and d.clientCode = c.clientCode
and d.companyCode = c.companyCode
and (p.dailyBalance <> 0)
and ((d.borrowLoanPledgeReceipt ="B") )
and (c.customerCategory <> "IG")
group by d.businessDate, d.companyCode, d.clientCode, d.cusip, c.customerCategory, d.borrowLoanPledgeReceipt, d.issueCurrency, d.strategyCode


Can you turn server side grouping off. It worked initially, and Ive been wondering if (as it returns a large data set) if the DBA has changed the server response.
Can a DBA see what pass through queries are coming through, is it likely that they would flag querys which produced result sets which were to large?

Thanks

Mordja

 

[dhookom]

Pass-through queries are not "JET SQL". I suggest you ask this question in a Sybase forum or News Group.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[PHV]

Perhaps because you use
DailyBalance=Sum(p.dailyBalance)
instead of
Sum(p.dailyBalance) As DailyBalance

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244