we tried different weight scenarios)

this one didnt work on one.

insert into #Person(PersonName, PersonHeight, PersonWeight, PersonBorn)

values ('Loskov', 180, 150, '1988-01-19'),

('Sychev', 190, 150, '1966-05-15'),

('Evseev', 174, 150, '1974-12-29'),

('Maminov', 166, 150, '1981-09-05'),

('Orlov', 176, 150,...

Bad news :crying:, it doesn’t work in every scenario. Neither of the queries. I tried changing the numbers and it only worked some times.

It divides the total weight by lift...

thanks so much!!!!!

and thanks for the article, i will also read it.

now people can ride safe on the elevator thanks to you 😎

of course that works and i was nowhere close to the answer :w00t:

but of course it worked 😀

now the million dollar question... the way i did it, how do i...

good morning, i would love to see your query, did you see mine?

i was sweet enough to butcher people to fit in the elevator hahahahah

Thanks for your reply but that is not it 🙂

i need to divide the people to fit in an elevator, and the total amount of weight on the elevator cannot...

ok, so now i am after my coffee

i found a temporary solution to the problem but i cuts people :w00t:

keeping in mind that i am all about peace and...

ok... it is official i am completely lost :w00t:

but i haven't had my coffee yet, therefore after i get a dose of caffeine, i will get to it 🙂

well i know more than just a little 🙂

and i dont want the result, i just want to understand, my ego cannot take it if someone will solve it :-D:-D

but...

😀 well i am looking into the bin thingy and doesnt look simple, there is a 6 page article with many many things :w00t:

and i thought this problem was going...

i never heard of the bin problem lol. but i will look into it 😀

i am trying to learn sql and i got asked to look into that.

thanks!

lol,

no no, that is not what i need

i need to run a query that will take the people and group them, in groups

each group cannot weight all together more...

Chris, i did what i asked. your query added groups to the dates. from 1 to 8 group 1, from 9 to 16 group 2 and so on and so...

ohhhhhhhhhhhhhhhhhhhh

now i understand... i am slow but i will get there lol.

so basically what i needed was the last two selects.

on my defense i am a sql on the making.......

yes i did, but i get confused, the "SELECT '2008-01-01 00:00:00.000', 3 UNION ALL" is not the one i need to add one by one manually?

the query returns around...