Unfortunately not, we're the one's who need to see it as the maximum discount for each product since we're purchasing the products. we want to see where we'll achieve the...

I don't use the exhibit in the final query to get the data. It is still necessary for us to have our exhibits included though as the parts discount is...

Hi again,

I've looked into your query and it just doesn't seem to work with the max(discount) in the select part of the query for the #temp table. I looked further...

Hi,

Thanks for the reply, That does help quite a lot actually, I'll try implementing the changes today and see how the work out for the results. I've been looking into...

In response to your post Sean i haven't changed around the joins as i don't fully understand how they work yet i need to do a little more reading into...

i'll give it ago now, thanks 😀

Thanks for your response, Since seeing the prior comments about my post and detail it possessed i thought I'd give you all the information possible at the moment. I've actually...

I've spent quite a bit of time making these queries for you to re-create our current database yourselves. You'll be able to see the entire makeup of it and i...

Hi again,

I'm going to the get the create statements and some sample data today for you guys to if you'd like to test it and further help me with...

I've read the article and it now is a lot clearer on how to post on this website, i'll have ago at re-writing the code myself and see what results...

Thanks for your help Sean,

I'll give you remainder of the tables for the variables,

weightkgs, warrantycode, product line, serialized, list price, prod class all come from the gbpricelist table where...

Thanks for your response Samalex, the application at the end is just simply a excel sheet. The problem is that no discounts are been included in the file with the...