The Artima Developer Community
Articles | News | Weblogs | Books | Forums
Artima Forums | Articles | Weblogs | Java Answers | News
Sponsored Link •

.NET Buzz Forum
Display 1 When Any Column Is 1 And 0 Otherwise by Using SIGN, SUM Or (Bitwise OR)

0 replies on 1 page.

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 0 replies on 1 page
Max Zone

Posts: 9170
Nickname: dzone
Registered: Jun, 2006

dzone.com is a link-sharing community where member participation determines what gets published
Display 1 When Any Column Is 1 And 0 Otherwise by Using SIGN, SUM Or (Bitwise OR) Posted: Dec 22, 2006 5:29 AM
Reply to this message Reply

This post originated from an RSS feed registered with .NET Buzz by Max Zone.
Original Post: Display 1 When Any Column Is 1 And 0 Otherwise by Using SIGN, SUM Or (Bitwise OR)
Feed Title: dzone.com: .net
Feed URL: http://www.dzone.com/feed/frontpage/.net/rss.xml
Feed Description: dzone.com: fresh .net links for developers 		Latest .NET Buzz Posts
Latest .NET Buzz Posts by Max Zone
Latest Posts From dzone.com: .net

Advertisement
You have three columns; if any of the columns is 1 you want to display 1 if they are all 0 you want to display 0. how can you do that? there are basically three ways to do this 1 SUM 2 SIGN 3 | (Bitwise OR)

Read: Display 1 When Any Column Is 1 And 0 Otherwise by Using SIGN, SUM Or (Bitwise OR)

Topic: db4o Version 6.0 Released Previous Topic   Next Topic Topic: Fine-tune Your Active Directory Operations with .NET
Sponsored Links


Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use