The Big Programming Thread - Page 423

On January 08 2014 21:51 nunez wrote:

Show nested quote +

On January 08 2014 20:05 darkness wrote:

On January 08 2014 09:50 nunez wrote:

On January 08 2014 07:55 darkness wrote:

On January 08 2014 04:36 Arnstein wrote:
CTRL+C does the trick I just wanted to look at how/if the number would go to 3.5 if I would take the average of X dice rolls, and then I could just CTRL+C when I wanted to stop.

Then

while (true)

may be better to write instead. It's more readable than

while (1)

Or even better:

bool loopShouldContinue = true;
while (loopShouldContinue) {
   // do your work
   // when you're finished
   loopShouldContinue = false;
   // or you could write
   break;
   // but then that may make the point of the boolean variable irrelevant 
   // it just depends on what you want to do exactly
}

Don't forget to import

#include <stdbool.h>

if you use the boolean approach.

#############################

I've got a question. When you don't need a class instance to do something (e.g. to get an unsorted array and return a sorted one), is it advisable to make that method static in general?

loopShouldContinue clearly does express the intention of the programmer precisely enough, it's even less expressive than while(1)!

try:
while(sinceThisProgramIsJustForMyOwnExperimentationThisLoopWillJustRunUntilITerminatedAtMyDiscretinonWithCtrlC)

Don't be so grumpy. The name of the boolean variable can be easily renamed, and it was just an example. You're just acting like an ass at the moment with your sarcasm.

your post was well-intentioned, but misguided and misplaced nitpicking, borderline overbearing... it persists!

while (true)

while (1)

SELECT *
FROM dbo.poslog t1
CROSS JOIN dbo.poslog t2
WHERE t1.receiptid != t2.receiptid
AND t1.subtotal + t2.subtotal = 553,90

SELECT t1.receiptid as Receipt1, t2.receiptid as Receipt2, -1 as Receipt3
FROM dbo.poslog t1
CROSS JOIN dbo.poslog t2
WHERE t1.receiptid != t2.receiptid
AND t1.subtotal + t2.subtotal = 553,90

UNION

SELECT t1.receiptid as Receipt1, t2.receiptid as Receipt2, t3.receiptid as Receipt3
FROM dbo.poslog t1
CROSS JOIN dbo.poslog t2
CROSS JOIN dbo.poslog t3
WHERE t1.receiptid != t2.receiptid AND t1.receiptid != t3.receiptid AND t2.receiptid != t3.receiptid
AND t1.subtotal + t2.subtotal + t3.subtotal = 553,90

...

with pairs as
(
   select 
     t1.receiptid id1, 
     t2.receiptid id2
  from 
     dbo.poslog t1 
  inner join 
     dbo.poslog t2 
  on 
     t1.subtotal + t2.subtotal = 553,90 
     and t1.receiptid != t2.receiptid
),
distinct_pairs as
(
    select
       t1.id1,
       t1.id2
    from
       pairs t1
    inner join
       pairs t2
    on
       t1.id1 = t2.id2
       and t1.id2 = t2.id1
       and t1.id1 > t1.id2
)
select
  t2.*,
  t3.*
from
  distinct_pairs t1 
inner join 
  dbo.poslog t2 
on 
  t1.id1 = t2.receiptid
inner join
  dbo.poslog t3
on 
  t1.id2 = t3.receiptid;