In my experience, people are quick to criticize and slow to praise, so it's heartening to see some good stories. Thanks.

The original question was using each number just once, so 1/3 + 2/3 = 1, though correct, is not applicable here as it won't happen.

I always liked maths and this caught my eye. An interesting look into the way SQL handles number types, thank you.

For my part I couldn't help trying to expand it...

Irish Flyer (2/11/2009)

---

Using Studio 9.00.3042.00

PRINT '1' -- /* ;PRINT '2' */ ;PRINT '3' /* PRINT '4' --*/

--/*

PRINT '5'

--*/

/*

PRINT '6'

--/*

*/

PRINT '7'

--*/

PRINT '8'

yields a return of:

1

5

8

The parser only shows PRINT '1' ,...

I'm using Microsoft SQL Server Management Studio version 9.00.2047.00

I get 1, 4, 5 and 8. Where has your 4 gone?

This is a new bit of information to me.

I would have agreed with Phillippe's logic and so would have expected the 7 to show, but when I ran it in...

This was an interesting question. I played with several dates and all I can say is that for each of the solutions, some work some of the time, but none...