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 @ 11:28 AM
Points: 5,370, Visits: 9,012
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 @ 4:53 AM
Points: 2,702, Visits: 1,695
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: Thursday, December 18, 2014 4:24 AM
Points: 495, Visits: 895
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 @ 1:08 AM
Points: 4,160, Visits: 5,557
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 @ 11:25 AM
Points: 2,880, Visits: 5,918
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


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, December 19, 2014 4:08 AM
Points: 547, Visits: 261
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: Monday, December 15, 2014 3:02 AM
Points: 912, Visits: 1,500
Excellent question, Wayne.
Thank you.


Best regards,

Andre Guerreiro Neto

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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 4:21 PM
Points: 7,928, Visits: 9,653
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: 314, 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