Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

BIT Conversions Expand / Collapse
Author
Message
Posted Monday, August 13, 2012 9:49 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:55 AM
Points: 5,364, Visits: 8,949
Comments posted to this topic are about the item BIT Conversions

Wayne
Microsoft Certified Master: SQL Server 2008
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #1344517
Posted Tuesday, August 14, 2012 1:23 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 5:17 AM
Points: 2,635, Visits: 1,647
Nice question. Surprised at the number selecting '0' as an answer though. 32% presently.
Post #1344541
Posted Tuesday, August 14, 2012 2:06 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 6:32 AM
Points: 472, Visits: 878
Ack! I can explain why the 32%.

I read the question and thought the trick was about the numbers that weren't 1 or 0 and went ahead and ticked all the boxes knowing they would all be inserted.

... but not all as True.

Doh!

My fault for not answering it carefully.

Post #1344560
Posted Tuesday, August 14, 2012 2:46 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:24 AM
Points: 4,018, Visits: 5,315
Good back-to-basics question, thanks Wayne

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1344572
Posted Tuesday, August 14, 2012 2:58 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:53 PM
Points: 2,822, Visits: 5,711
Doh!

Good question, my bad for missing the as True/ 1 part. I knew they would all insert correctly...

Must remember to read question after having coffee!

Rodders...




Post #1344577
Posted Tuesday, August 14, 2012 4:12 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, June 12, 2014 4:19 AM
Points: 701, Visits: 1,145
I was very careful with this one. Have been burnt too many times by not reading the question closely. Great question Wayne!
Post #1344598
Posted Tuesday, August 14, 2012 4:13 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, January 31, 2014 2:56 AM
Points: 483, Visits: 256
Good one. Once again I fell right into the trap. Must remember to RTFQ / RTFS (Read the **** Question / Statement)
Post #1344601
Posted Tuesday, August 14, 2012 4:59 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 1:04 PM
Points: 900, Visits: 1,490
Excellent question, Wayne.
Thank you.


Best regards,

Andre Guerreiro Neto

Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2
Post #1344612
Posted Tuesday, August 14, 2012 5:47 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Sunday, October 19, 2014 11:12 AM
Points: 7,791, Visits: 9,545
Good question.

A lot of careless readers around today - 31% (about 80) so far have picked 0, and I suspect the number of those who picked that for some other reason that having misread the question is very small indeed.


Tom
Post #1344623
Posted Tuesday, August 14, 2012 5:47 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, August 25, 2014 4:06 AM
Points: 312, Visits: 164
Good question, my bad is I just ignored 1 so I checked only -1 and 25 I missed out 1
Post #1344625
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse