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: Yesterday @ 7:36 PM
Points: 6,593, Visits: 8,874
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 @ 7:33 AM
Points: 2,580, Visits: 1,622
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: Tuesday, August 12, 2014 10:57 PM
Points: 458, Visits: 857
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


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 1:22 PM
Points: 3,902, Visits: 5,075
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:20 AM
Points: 2,978, Visits: 5,380
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: Thursday, August 7, 2014 7:57 AM
Points: 897, Visits: 1,487
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


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 9:14 AM
Points: 8,679, Visits: 9,205
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: Wednesday, June 4, 2014 5:36 AM
Points: 306, Visits: 162
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