108 reputation
2
bio website
location
age
visits member for 3 years, 3 months
seen May 7 at 22:00

Nov
15
awarded  Scholar
Nov
15
accepted How do I query based on percentages of a subset of values?
Sep
14
awarded  Student
Sep
12
comment How do I query based on percentages of a subset of values?
The WITH syntax along with UNION ALL is something I hadn't thought of. Thanks. But it's not dynamic; the query would have to change to select only one type or 3 types, etc.
Sep
6
comment How do I query based on percentages of a subset of values?
Not hard coded. It needs to be dynamic. So yes, passed in as variables. Ex: one execution could be 100% A. Another 50% B, 12% D and 38% E.
Sep
6
comment How do I query based on percentages of a subset of values?
Order does not matter, as long as the amounts match the percentages as closely as possible.
Sep
6
asked How do I query based on percentages of a subset of values?