Eugene Elutin (7/24/2013)
Sean Lange (7/24/2013)
I would have to say that is an absolutely horrid interview question. It is not testing your skills with sql server. I have seen the binary AND around the forums but I have never come across it in the real world (at least not in sql server).It's called "Bitwise AND" :
http://msdn.microsoft.com/en-us/library/ms174965.aspx
I have used it few times...
I'll try to find one thread on this forum where I've used it to help to achieve quite interesting requirements.
I knew it wasn't binary AND but couldn't think of the proper name for the life of me. 😛
If you can find that thread it would be interesting.
I still say it is a poor interview question because it so rarely used.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/