yuvipoy (5/20/2014)

---

vignesh.ms (5/20/2014)

---

Hi there,

here is the sample

create table Sample (id int ,value int,total int)

insert into Sample (id,value) values (1,1)

insert into Sample (id,value) values (1,4)

insert into Sample (id,value)...

Table structure is same... Data only differs

It will always starts and...

this is not the fine answer & also not mine...

It took much time to solve 1000 , so given answer is for 100

WITH Base(N) AS(

SELECT 1 UNION...

LutzM (4/19/2014)

---

Your question is "Need query for problem".

Would you mind sharing the logic you came up with to solve the problem? We might be able to help you "translate" it...

Louis Hillebrand (4/18/2014)

---

This looks me as a homework job, so the OP has to find the solution, that's why I didn't give the query,

Just a hint: Min quantity = 1,...

J Livingston SQL (4/18/2014)

---

ok...here is...

This is an EXTREMELY complex algorithm. It is similar to the bin packing problem. Both of these are incredibly complex mathematical calculations. Did you even use google as Dwain suggested?...

Should be mixture of all products..

I'm eagerly waiting for the query....

Pls try it out..

Any help ??

Hello all,

I myself prepared query for the above scenario...

But have some deviation...

I could not able to retrieve last row in the given output

;with cte as (

select ROW_NUMBER() over(order...

higgim (4/9/2014)

---

By no means elegant and I have not tested this with any other data than what you have provided but it does give you the expected results based on...

higgim (4/9/2014)

---

I have had a quick look at this and need to ask:

Your desired output

YYY Ret1 35

YYY 25

Where...

Anybody help ??

how to assign all at once ?

We should combine all the products in...