Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Missing If statement using Bitwise operators

Posted on 2009-05-04
3
Medium Priority
?
359 Views
Last Modified: 2012-05-06
Hi all you experts I am trying to convert a number to a true/false statement. True if the bit is on.

Below is my data:
Ident  Device                    Shelf   Row          count bit
15        TubeStore0113      10             2               7

I want to convert 7 into position 1,2,3 are on and position 4 is off based on the bit value.
Below I & the bit with the column 1-4 and got a return of 1,2,4,8 which is correct, but I guess I am having trouble changing that value to true/false.

So how would I add an If statement around each column and retrun true if the value > 0
SELECT     TOP (1) Ident, DeviceName, Shelf, Row, CoumnCount, CountBit, TubeCount, CountBit & 1 AS Column1, CountBit & 2 AS Column2, 
                      CountBit & 4 AS Column3, CountBit & 8 AS Column4
FROM         dbo.TempBitCountByShelf
WHERE     (DeviceName = N'TubeStore0113') AND (CoumnCount = 3)
ORDER BY Ident

Open in new window

0
Comment
Question by:TraciShultz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 41

Accepted Solution

by:
ralmada earned 2000 total points
ID: 24295775
Do you mean something like this?
 

SELECT ...
	CASE WHEN CountBit & 1 > 1 THEN 'TRUE' ELSE 'FALSE' END AS Column1, 
	CASE WHEN CountBit & 2 > 1 THEN 'TRUE' ELSE 'FALSE' END AS Column2, 
	CASE WHEN CountBit & 4 > 1 THEN 'TRUE' ELSE 'FALSE' END AS Column3, 
	CASE WHEN CountBit & 8 > 1 THEN 'TRUE' ELSE 'FALSE' END AS Column4
FROM ...

Open in new window

0
 

Author Closing Comment

by:TraciShultz
ID: 31577571
Excellent solution.
0
 

Author Comment

by:TraciShultz
ID: 24295859
Final Solution:
SELECT     TOP (100) Ident, DeviceName, Shelf, Row, CoumnCount, CountBit, TubeCount,
                      CASE WHEN CountBit & 1 > 0 THEN 'TRUE' ELSE 'FALSE' END AS Column1, CASE WHEN CountBit & 2 > 0 THEN 'TRUE' ELSE 'FALSE' END AS Column2,
                       CASE WHEN CountBit & 4 > 0 THEN 'TRUE' ELSE 'FALSE' END AS Column3,
                      CASE WHEN CountBit & 8 > 0 THEN 'TRUE' ELSE 'FALSE' END AS Column4
FROM         dbo.TempBitCountByShelf
WHERE     (DeviceName = N'TubeStore0113')
ORDER BY Ident
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question