Viewing 14 posts - 1 through 14 (of 14 total)
Thanks everyone, I eventually managed to solve it and will stick the code up sometime soon, Hopefully it will be acceptable 😀
June 6, 2013 at 2:27 pm
Thanks, so the idea is to build a tally table on the fly and select from that for my query is that correct?
June 6, 2013 at 9:37 am
Ok, That helps a little, I thought I would be able to figure out the rest but alas, what I need is a counter to add the integers until we...
June 6, 2013 at 9:17 am
Yes, thanks guys! its worked 🙂 I am not sure why, but that is how I have been instructed to calculate it, instead of the individual audit I am to...
June 5, 2013 at 3:39 pm
@ JEff, When grouping we have to add every column that is not part of an aggregate function to the group by clause, this then alters the results accordingly, (learnt...
May 3, 2012 at 7:05 am
Thanks guys, It turns out my db design was the problem so it overly complicated the querying process! What I needed was to select some aggregated values, and some contact...
May 3, 2012 at 6:57 am
Evil Kraig, yes that is simmilar to what Im looking for!!
Unfortunately its not as simple as the wrong data as suggested by the 2nd poster!
May 2, 2012 at 3:22 pm
I seem to have overcome my initial issue but come up to another dead end (so to say) and cant make out what your query is doing exactly, I...
February 16, 2012 at 5:23 am
@AndyHyslop Thanks that is almost what I am after, customers who have not bought products b and c however I only want results from these customers (who haven't bought b...
February 9, 2012 at 7:21 am
I am trying to say give me all customer numbers and their total purchases SUM() for those customers who have bought product b and any other products besides c and...
February 9, 2012 at 6:30 am
ignore the syntax above, I did include the FROM in the subquery
February 9, 2012 at 5:04 am
That was the first thing I thought of, problem with that is it also gives me the customers who have not bought the products in the IN() part of...
February 9, 2012 at 5:03 am
Yes that is correct, It seems that using IN() will do the trick!
To find a customer that has purchased one product and not another can I use somthing like this?
February 8, 2012 at 3:39 pm
February 8, 2012 at 8:55 am