Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Distribution during Quantiles

Status
Not open for further replies.

Liam1

Programmer
Nov 7, 2002
43
GB
Hello,

We are trying to quantile a large number of rows.

We have ran this code before and it ran fine.
The code is:

Select
Cust_ID
,quantile(100, Profit - ZeroIfNull(ABS(Acc_Amt))/12) as Perc
From
Customer_Table

We have tried removing the calculation, so we are quantiling a single value (e.g. just the Profit component), and we have tried the ANSI compliant syntax, but this fails too.

What seems to be happening is - at 1st the amps spool up nice and evenly, then the optimiser places EVERYTHING onto one AMP....
Is this 'normal' behaviour?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top